tricky sql statement error from ado querry

N

Nosreg

Ok: this works:
SELECT * FROM Table1 WHERE Name Like "*ca*";
in Access 2002 it returns "Spagetti carbonara"

If I do it from html with an ADO object I change * to %25 it like this:
SELECT * FROM Table1 WHERE Name Like "%25ca%25";
the result is no match
put the following string give the right result:
"%25 ca%25" with a space on first place
"%25Spaghetti carbonara%25"
"%25arb%25"
this happens also with another recordset with " ca..."
any ideas?
 
Top