Solved

Access SQL Like * Query

Posted on 2002-07-23
3
501 Views
Last Modified: 2012-06-21
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
Comment
Question by:Del_Boy_ie
  • 2
3 Comments
 
LVL 86

Accepted Solution

by:
CEHJ earned 50 total points
ID: 7171364
This is because it's not standard SQL syntax. Try:


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

It might even work in Access!
0
 

Author Comment

by:Del_Boy_ie
ID: 7171381
Chhers mate the pts are yours
0
 

Author Comment

by:Del_Boy_ie
ID: 7171388
Chhers mate the pts are yours
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
solarwind tftp server 2 44
Problem to start Neon 20 85
Apps blocked by Java 9 60
reverse digits of a number using for loop 5 36
For beginner Java programmers or at least those new to the Eclipse IDE, the following tutorial will show some (four) ways in which you can import your Java projects to your Eclipse workbench. Introduction While learning Java can be done with…
Java had always been an easily readable and understandable language.  Some relatively recent changes in the language seem to be changing this pretty fast, and anyone that had not seen any Java code for the last 5 years will possibly have issues unde…
Viewers learn about the third conditional statement “else if” and use it in an example program. Then additional information about conditional statements is provided, covering the topic thoroughly. Viewers learn about the third conditional statement …
Viewers will learn about the different types of variables in Java and how to declare them. Decide the type of variable desired: Put the keyword corresponding to the type of variable in front of the variable name: Use the equal sign to assign a v…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now