simple questions i think 2

[krappleby025]

i have an sql query

set rs=conn.execute("SELECT * FROM products where class LIKE '" & maingroup & "' ORDER BY autonumber&quot

and i need to pull any records that contain the maingroup variable, ie if maingroup = test

then i want to pull all with the word test in them

ie

metest
me test
test me
testme
test
complete test phase

etc... how do i do it, i know it has something to do with the * but cant work out where to put it

thanks

 

[Tarwn]

You need some wild cards in your stetment:

set rs=conn.execute("SELECT * FROM products where class LIKE '%" & maingroup & "%' ORDER BY autonumber")

Some db's use %'s some db's use *'s as wildcards, the above should work for you now.

-Tarwn --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---
Can't...think...of...anything...funny...to.........say............
need.....coffee....................

 

[GaryC123]

set rs=conn.execute("SELECT * FROM products where class LIKE '%" & maingroup & "%' ORDER BY autonumber&quot

Putting % before and after will return all records containing the phrase. Saturday 12.00

20.00

3.00am

Sunday [img http

 

[krappleby025]

thanks