query with a variable

[mansouri]

SELECT bnn.detail, *<br>FROM bnn<br>WHERE (((bnn.detail) LIKE&nbsp;&nbsp;'%%toto%%%'))<br>&nbsp;<br>ORDER BY bnn.titre;<br>&nbsp;<br>I have a web page with a form in wich a customer search&nbsp;&nbsp;a word from a field called detail in my DB bnn;this query with the variable TOTO works fine&nbsp;&nbsp;but gives only the result if the word put in the form is like the first word in the field detail in my DB ; and other word inserted in the variable won't give a match unless it's the first word in the field detail.<br>How to search for a word inside the field detail? not the first word .<br>For your info the property of the field detail is memo&nbsp;&nbsp;thanks<br>&nbsp;<br>&nbsp;<br>&nbsp;<br>&nbsp;<br>

 

[samara]

you can use this syntax,,,<br><br>LIKE * & your variable & *<br><br>I hope this would help you... <p>Mohamed Aly<br><a href=mailto:samara_79@hotmail.com>samara_79@hotmail.com</a><br><a href= > </a><br>

 

[Guest_imported]

this was answered 2 other times on your last post and the same way. Did the other suggestions not work???