To pull all emails from the domain-aol.com

[mansi sharma]

Que-) Create a Query to pull all emails from the domain-aol.com. This field is called ADR_EMAIL in the X Table.

select ADR_EMAIL From X

I do not understand what d question means,I simply select that field from the table As Above. Its Rite??

[deepuv04]

Que-) Create a Query to pull all emails from the domain-aol.com. This field is called ADR_EMAIL in the X Table.

select ADR_EMAIL From X

I do not understand what d question means,I simply select that field from the table As Above. Its Rite??

hi
try the following....

[code=sql]
select ADR_EMAIL From X where ADR_EMAIL Like '%aol.com%'
[/code]

[mansi sharma]

Thx
,it worked Out.