Email Database Question

[Jman311311]

I have a database with a lot of emails in it. The emails are in a field called EMAIL. I want to get rid of all yahoo email addresses. How do I delete any emails that end with "@YAHOO.COM"?

Just in case you were wondering, all the emails are upper cased. Thanks in advance for your help.

Jarrett

 

[JRB-Bldr]

USE MyData IN 0 EXCLUSIVE
SELECT MyData
DELETE FOR "@YAHOO.COM" $ UPPER(Email)
PACK
USE

Good Luck,
JRB-Bldr

 

[Jman311311]

It worked...You are the man JRB-BLDR. Thanks again for your help.