Retrieve Email address query

  • Thread starter Thread starter Simon Gare
  • Start date Start date
S

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.
 
Simon said:
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.
Click to expand...


instead of saying fieldName = '@' try fieldName like '*@*'
 
Simon said:
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.
Click to expand...


instead of saying fieldName = '@' try fieldName like '*@*'
 
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
 
Back
Top