Wildcard in query

[schwankieog]

i need to be able to use a wild card sucj as * in a query. unfortunately the following sql statement while working in access does not work via asp:
"select dept.* from dept where (((dept.name) Like "*var*&quot);"
any help would be appreciated.

 

[csiwa28]

When coding in asp the wildcard '*' doesn't work. U have to use '%'.

Like "%var%&quot);"

 

[schwankieog]

thanx