[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 541
  • Last Modified:

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??
0
Del_Boy_ie
Asked:
Del_Boy_ie
  • 2
1 Solution
 
CEHJCommented:
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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now