Solved

Access SQL Like * Query

Posted on 2002-07-23
3
510 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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
java.io.BufferedReader   readLine()  //returns the entire file ? 4 73
Windows 10 IE Certificate Issue 10 45
MySqlDump not dumping triggers 1 31
web application structure 18 77
For customizing the look of your lightweight component and making it look opaque like it was made of plastic.  This tip assumes your component to be of rectangular shape and completely opaque.   (CODE)
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 how to read error messages and identify possible mistakes that could cause hours of frustration. Coding is as much about debugging your code as it is about writing it. Define Error Message: Line Numbers: Type of Error: Break Down…
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.

773 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