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

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

mharcais

ASKER

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

SOLUTION