Post reply

sp_send_dbmail - Quotes in mail id

  • December 11, 2012 at 6:17 am

    #267908

    I have to send mail from SQL 2008 to an id James.T'Cooper@zzzzz.com

    Since the id has quotes ('), am getting syntax error. How to resolve this?

  • December 11, 2012 at 7:07 am

    #1567427

    balasach82 (12/11/2012)

    I have to send mail from SQL 2008 to an id James.T'Cooper@zzzzz.com

    Since the id has quotes ('), am getting syntax error. How to resolve this?

    Add in the CHAR(39) keyword where the ' goes

    So 'James.T+'CHAR(39)+'Cooper@zzzzz.com'

    Or 'James.T''Cooper@zzzzz.com'

  • December 11, 2012 at 8:06 am

    #1567461

    Anthony,

    Thanks. Let me try both the ways and get back to you on how it went.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply