wildcard search query

Fary4u · #1 June 7th, 2009, 10:40 AM

Hi

i'm trying to search the value in my following field productDescc.
i don't know why it's not bring result giving me no error

Expand|Select|Wrap|Line Numbers

 select * FROM products WHERE (products.CatalogID='" & strCatalogID & "') AND (products.productDescc like '%" & styno & "%') ")
 

styno bring result.

Fary4u · #2 June 7th, 2009, 04:01 PM

have a look ths one might b u can help me same post in sql

like statment

jhardman · #3 June 10th, 2009, 02:02 PM

print out the queries in both cases. I bet you will see that you have a simple typo.

Jared

re: wildcard search query