SQl,Access and query please help

[mansouri]

Hi I have this query<br>SELECT bnn.detail, * <br>FROM bnn <br>WHERE (((bnn.detail) like '%%toto%%%')) <br>ORDER BY bnn.titre <br><br>working on bnn.mdb it's purpose to find a word in the form toto and search it in the field detail of bnn.mdb<br>the probleme is it gives me only the result when the matching word is the first one inserted in the field detail wish it's property is memo and contains details of news .<br>but I need to search&nbsp;&nbsp;for the llike of this word&nbsp;&nbsp;any where in the the field of detail.&nbsp;&nbsp;&nbsp;your help is appreciated thanks&nbsp;&nbsp;&nbsp;&nbsp;Slim<br>

 

[Guest_imported]

I've had success with<br>WHERE (((BNN.Detail) Like &quot;*&quot; & [toto] & &quot;*&quot);

 

[peitzza]

i'm not quite sure i know exactly what your talking about but you might try the following after your LIKE operator<br><br>LIKE &quot;*&quot;&&quot;toto&quot;&&quot;*&quot)<br><br>this will find any occurrence of &quot;toto&quot; in your &quot;detail&quot; field because its searching for *toto* in essence.<br><br>P.S. just in the slight case you dont know... * means wildcard-number of any characters. <p>Peter Heaton<br><a href=mailto:heaton@characterlink.net>heaton@characterlink.net</a><br><a href=

http://castle.chaffee.net/~heaton>Take

it how ever you want</a><br>