Post reply

Very simple T-SQL Concatination Problem

  • June 18, 2009 at 7:49 pm

    #207172

    Would like to return "Healthy" + Type. Where 'Type is the column name in my table. For example;

    SELECT ID, ("Healthy" + Type) AS NewType

    FROM tblType

    this should return something like below. Thank you.

    ------------------------------

    ID NewType

    1 Healthy Banana

    2 Healthy Apply

    3 Healthy Carrot

  • June 18, 2009 at 7:52 pm

    #1012140

    [font="Verdana"]Use the single quote, not the double quote (think C not Basic.)

    SELECT ID, 'Healthy ' + Type AS NewType

    FROM tblType

    [/font]

  • June 18, 2009 at 7:57 pm

    #1012142

    Thank you Bruce. This worked. Appreciate your time.

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

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