Retrieve Email address query

[Simon Gare]

Hi all,

need to run a query on a table that only shows email addresses have tried =
@ etc but no joy. Mixed data in field doesn't help.

Regards
Simon


www.thegaregroup.co.uk website: www.privatehiresolutions.co.uk The Gare
Group Ltd Saverstores UK Ltd Private Hire Solutions Ltd EPrivateHire Ltd So
Good at IT ltd This email, and any attachment, is confidential. If you have
received it in error, please delete it from your system, do not use or
disclose the information in any way, and notify me immediately. The contents
of this message may contain personal views, which are not the view of any
member of The Gare Group Staff, unless specifically stated. If you are not
the intended recipient, be advised that you have received this email in
error and that any use, dissemination, forwarding, printing or copying of
this email is strictly prohibited. If you have received this email in error,
please notify the sender by replying to the email or by telephone on 0845
0048602 Thank you.

 

[Matt]

Hi all,

need to run a query on a table that only shows email addresses have tried =
@ etc but no joy. Mixed data in field doesn't help.

Regards
Simon


www.thegaregroup.co.uk website: www.privatehiresolutions.co.uk The Gare
Group Ltd Saverstores UK Ltd Private Hire Solutions Ltd EPrivateHire Ltd So
Good at IT ltd This email, and any attachment, is confidential. If you have
received it in error, please delete it from your system, do not use or
disclose the information in any way, and notify me immediately. The contents
of this message may contain personal views, which are not the view of any
member of The Gare Group Staff, unless specifically stated. If you are not
the intended recipient, be advised that you have received this email in
error and that any use, dissemination, forwarding, printing or copying of
this email is strictly prohibited. If you have received this email in error,
please notify the sender by replying to the email or by telephone on 0845
0048602 Thank you.

instead of saying fieldName = '@' try fieldName like '*@*'

 

[Matt]

Hi all,

need to run a query on a table that only shows email addresses have tried =
@ etc but no joy. Mixed data in field doesn't help.

Regards
Simon


www.thegaregroup.co.uk website: www.privatehiresolutions.co.uk The Gare
Group Ltd Saverstores UK Ltd Private Hire Solutions Ltd EPrivateHire Ltd So
Good at IT ltd This email, and any attachment, is confidential. If you have
received it in error, please delete it from your system, do not use or
disclose the information in any way, and notify me immediately. The contents
of this message may contain personal views, which are not the view of any
member of The Gare Group Staff, unless specifically stated. If you are not
the intended recipient, be advised that you have received this email in
error and that any use, dissemination, forwarding, printing or copying of
this email is strictly prohibited. If you have received this email in error,
please notify the sender by replying to the email or by telephone on 0845
0048602 Thank you.

instead of saying fieldName = '@' try fieldName like '*@*'

 

[Ken Sheridan]

Simon:

If you are searching on a substring then use the LIKE operator and wildcard
characters. To find all which include an @ sign, i.e. to distinguish
hyperlinks to email addresses from those to files for instance:

LIKE "*@*"

To find all yahoo addresses say:

LIKE"*@yahoo*"

Ken Sheridan
Stafford, England

 

[Simon Gare]

Thanks,

Simon