wildcard search query

Fary4u

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

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

like statment

jhardman

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

Jared

re: wildcard search query