Post reply

SQL Catenate & adding additional characters

  • July 22, 2009 at 7:33 am

    #223868

    I have the following SQL statement:

    Select email_address = (client_email + Client_email_domain)

    FROM client_contact

    Neither of the colulns contain "@" therefore I need to add in the @ in the results...

    (client_email + "@"+ Client_email_domain)

    Can this be done?

    Thanks

  • July 22, 2009 at 7:34 am

    #1028307

    ok so i answered it my self:

    Select email_address

    = (client_email + '@' +Client_email_domain) FROM client_contact

    where Client_email_domain NOT like '%gmail%'

  • July 24, 2009 at 6:24 am

    #1029600

    dont you need a .com or .org or .gov etc...at the end 😉

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

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