Post reply

Alias in a CASE Statement

  • May 4, 2010 at 1:39 pm

    #386850

    Hello Everyone

    Where does the Alias reside when using a CASE Statement?

    I have tried a couple places, after the column name, after the END statement, before the END statement. But I am still receiving an error.

    Thanks

    Andrew

  • May 4, 2010 at 1:46 pm

    #1162074

    show what you have so far, and the actual error.

    Case <column> when <value> then <value> else <value> end as <Alias>

    -- Cory

  • May 4, 2010 at 1:49 pm

    #1162075

    I got it now.

    Thanks

    Andrew SQLDBA

  • August 3, 2018 at 1:43 am

    #2000119

    How ?

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

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