|
FAQ #3: I have a query utilizing
LIKE that works great in Access but produces an error in ASP.
This is a very common error message when querying databases and the person learned to
query in Access. Access uses * for multiple character wildcards and ? for individual
character wildcards.
Let us look at 2 typical Access Query statements:
SELECT * from customer where city LIKE "N*"
works fine in Access! produces an error in ASP.
SELECT * from customer where city LIKE "N%"
works fine in ASP.
SELECT * from customer where phrase LIKE "N?w"
works fine in Access! produces an error in ASP.
SELECT * from customer where phrase LIKE "N_w"
works fine in ASP.
|