Proper Wildcard * or %

  • Thread starter Thread starter Van T. Dinh
  • Start date Start date
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).
 
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
 
Back
Top