using LIKE in MS ACCESS queries
I was getting bizarre results the other day when using LIKE in an ACCESS query – it turns out then when creating a query in SQL view inside Access you need to use * as a wildcard, but from within ASP you use %.
for example:-
SELECT foo FROM Bar WHERE foo LIKE ‘*Bar*’ <– within Access
SELECT foo FROM Bar WHERE foo LIKE ‘%Bar%’ <– from within ASP
returns the same dataset.
amin b nagpure 2007-05-22 08:15:56
Rick 2007-05-22 08:34:19