A
Al S
How can I query an @ sign that's in a data base?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Kevin3NF
SELECT Table1.email
FROM Table1
WHERE (((Table1.email) Like "*" & "@" & "*"));
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
FROM Table1
WHERE (((Table1.email) Like "*" & "@" & "*"));
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
B
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 "*[@]*"
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 "*[@]*"
B
Bruce M. Thompson
How can I query an @ sign that's in a data base?
Ummm ... the brackets are not needed with the "@" character. My bad.
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.