word like '%abc%' 1

[woutput]

Hello there,

I have a huge (200.000+) list of words (table called WORDS, 1 column called WORD)
I use this query:

Query = "SELECT * FROM WORDS WHERE WORD LIKE '%" & INFOSTRING & "%'"

to search for a WORD containing INFOSTRING.
But I want to search for a INFOSTRING containing WORD, how do I do that?

 

[r937]

perhaps you could show us an example, showing a few rows of data from the table?

r937.com | rudy.ca

 

[PHV]

You wanted this ?
Query = "SELECT * FROM WORDS WHERE '" & INFOSTRING & "' LIKE '%' || WORD || '%'"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[woutput]

Thanks!

Query = "SELECT * FROM WORDS WHERE '" & INFOSTRING & "' LIKE '%' || WORD || '%'"

is the solution to my problem.