Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Access SQL Like * Query

Posted on 2002-07-23
3
Medium Priority
?
539 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 86

Accepted Solution

by:
CEHJ earned 200 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

Tech or Treat!

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

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

By the end of 1980s, object oriented programming using languages like C++, Simula69 and ObjectPascal gained momentum. It looked like programmers finally found the perfect language. C++ successfully combined the object oriented principles of Simula w…
Introduction This article is the second of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers the basic installation and configuration of the test automation tools used by…
Viewers will learn one way to get user input in Java. Introduce the Scanner object: Declare the variable that stores the user input: An example prompting the user for input: Methods you need to invoke in order to properly get  user input:
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:
Suggested Courses

636 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