Post reply

JinuRtaJuly2

  • July 2, 2008 at 12:42 am

    #188896

    How Can I concatenating three string and stoer it

    s = 'qww' + 'qwe' + 'ddff'

    concatenating Three variable to form new one

  • July 2, 2008 at 1:34 am

    #837026

    jinumichael_alp (7/2/2008)

    How Can I concatenating three string and stoer it

    s = 'qww' + 'qwe' + 'ddff'

    concatenating Three variable to form new one

    DECLARE @variable1 VARCHAR(100)

    DECLARE @variable2 VARCHAR(100)

    DECLARE @variable3 VARCHAR(100)

    SET @variable1 = 'part1 '

    SET @variable2 = 'part2 '

    SET @variable3 = 'part3 '

    DECLARE @variableConcatenated VARCHAR(300)

    SET @variableConcatenated = @variable1 + @variable2 + @variable3

    SELECT @variableConcatenated

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

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

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