using select to retrieve rows which store email addresses

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I am storing in an SQL table data including email addresses. When trying to
retrieve via the Select function irows ncluding an email address, the program
traps because the @ character witin the select statement is a reserved
symbol.

How can i find rows in a table which include email addresses, such that the
@ symbols is not interpreted as a special symbol but part of a string
parameter.

I tried to use "\@" instead of @ but it doesent work.

Any suggestions are most appreciated,


Daniel
 
Hi Daniel,

You should just be able to put the whole email address in a string in single quotes. For eg. '(e-mail address removed)'

Hope that helps,

Michelle Hlaing

Microsoft Support Professional

***Disclaimer: This posting is provided "as is" with no warranties and confers no rights.***
--------------------
 
Back
Top