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??
Del_Boy_ieAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
CEHJConnect With a Mentor Commented:
This is because it's not standard SQL syntax. Try:


SELECT * FROM Employees WHERE Address Like '%d%';

It might even work in Access!
0
 
Del_Boy_ieAuthor Commented:
Chhers mate the pts are yours
0
 
Del_Boy_ieAuthor Commented:
Chhers mate the pts are yours
0
All Courses

From novice to tech pro — start learning today.