Last post Dec 28, 2009 11:12 AM by mandrews1234
Dec 28, 2009 10:24 AM|mandrews1234|LINK
I just wrote a query select * from tblUsers where lastname like '%parker%' and it returned nothing. However, if I write select * from tblUsers where lastname like 'parker'. It returns one result for a person named tricia parker. Any ideas why the % returns
Dec 28, 2009 10:37 AM|subhash.sheladia|LINK
can you give me database details?
which database are you using?
Dec 28, 2009 10:38 AM|Mikesdotnetting|LINK
If you are running the query form within Access the wildcard character is *. If you are querying the database (mdb file) using Jet or ODBC, the wildcard character is %.
Dec 28, 2009 11:12 AM|mandrews1234|LINK
That makes sense thanks.