Del_Boy_ie
asked on
Access SQL Like * Query
I have a problem with retrieving a record set. I have a query that works in access
SELECT * FROM Employees WHERE Address Like '*d*';
But when I try to use this in java I don't retrieve any results. The problem is with the asterisks as if i leave them out the query will work.
I need the asterisks left in though
Can any one help me out here??
SELECT * FROM Employees WHERE Address Like '*d*';
But when I try to use this in java I don't retrieve any results. The problem is with the asterisks as if i leave them out the query will work.
I need the asterisks left in though
Can any one help me out here??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Chhers mate the pts are yours
ASKER