Query an @ sign

[Al S]

How can I query an @ sign that's in a data base?

 

[Kevin3NF]

SELECT Table1.email
FROM Table1
WHERE (((Table1.email) Like "*" & "@" & "*"));


--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

 

[Bruce M. Thompson]

How can I query an @ sign that's in a data base?

Enclose the "@" in square brackets. If you are looking for a record where a
field *contains* an "@", then this is how the field's criteria would look in the
query builder grid:

Like "*[@]*"

 

[Bruce M. Thompson]

How can I query an @ sign that's in a data base?

Enclose the "@" in square brackets. If you are looking for a record where a
field *contains* an "@", then this is how the field's criteria would look in the
query builder grid:

Like "*[@]*"

Ummm ... the brackets are not needed with the "@" character. My bad.