% and * not consistent

[BeemerBiker]

% works fine in the Access SQL query windows. % does not work at all in C# code using the AccessDataSourc e.SelectCommand . I have to use * for my wildcard in dotnet c#

I tried googleing my question but got too many hits because of those symbols

Is there some meta command where I can tell asp dotnet access to use % instead of * ?

unaccountably, % also seems to work fine in perl using

$dbh = DBI->connect('dbi:O DBC:driver=micr osoft access driver (*.mdb);dbq='.
etc


just seems to be a problem in VS2008 with C# and asp dotnet.

thanks for looking

[ChipR]

You'll get plenty of leads if you google with the words "percent" and "asterisk"

[NeoPa]

ANSI Standards in String Comparisons may help, at least with understanding where the complications come from.

NB. I would expect that the ANSI-92 standard (% & _) is where everything will move to eventually.