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 for the llike of this word any where in the the field of detail. your help is appreciated thanks Slim<br>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQl,Access and query please help
- Thread starter mansouri
- Start date
Guest_imported
New member
- Jan 1, 1970
- 0
I've had success with<br>WHERE (((BNN.Detail) Like "*" & [toto] & "*"
);
);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 "*"&"toto"&"*")<br><br>this will find any occurrence of "toto" in your "detail" 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= it how ever you want</a><br>
)<br><br>this will find any occurrence of "toto" in your "detail" 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= it how ever you want</a><br>- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question