Proper Wildcard * or %

V

Van T. Dinh

Yep.

The Access GUI and DAO use "*" and "?". From ASP, you probably uses ADO and
the equivalents are "%" and "_" (underscore character).
 
D

Dan

Ive been making an asp page that uses WHERE something LIKE "%text%".
this has been working fine. when i copy and past the same exact thing
into access it just returns with no results.

I do get the propper results if i change the %'s to *'s..

Is this normal, or is there a right time to use each one?

Thank you
 
Top