asked on

Search for a particular string

Hi,
My table is called Emails and the email field is called Email.
I want to run a query for all email addresses with a particular extension. Here's what I have (but it's not working), please assist:

SELECT Email
FROM Emails
WHERE (((Emails.Email)="%.pl%"));

When that didn't work, I tried this one:

SELECT Email
FROM Emails
WHERE (((Emails.Email)="#.pl#"));

Neither bring me back any results, though there are plenty of records matching this criteria....

mbizup

Use LIKE:

SELECT Email
FROM Emails
WHERE (((Emails.Email) LIKE "%.pl%"));

Ashish Patel

Use like instead of =

entcee

try

SELECT Email
FROM Emails
WHERE ((Emails.Email) LIKE '%.pl%');

Jinesh Kamdar

SELECT Email
FROM Emails
WHERE (((Emails.Email) like "%.pl%"));

entcee

at least I was not the last person :)

mharcais

ASKER

HI!
Blank.... draws nothing back.

I'm pulling my hair out here! IF I do a search for .pl as a part of the field in the table, I get tons, but within the query... NOTHING!

ASKER CERTIFIED SOLUTION

mbizup

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mharcais

ASKER

By the way, this query is for an Access 2003 database...

SOLUTION