Post reply

Derived column question with ISNULL

  • Smash125

    Hall of Fame

    Points: 3527

    December 16, 2013 at 10:59 am

    #286161

    I have very simple requirement. I would have done this at the query level. Just wanted to learn how to do it in SSIS also

    CASE WHEN MiddleName IS NULL THEN FirstName + ' ' + LastName ELSE FirstName + ' ' + MiddleName + ' ' + LastName END AS FullName

    Just wanted to check how i can use ISNULL in derived column to build new column

  • Smash125

    Hall of Fame

    Points: 3527

    December 16, 2013 at 11:07 am

    #1673813

    ISNULL( MiddleName)? FirstName + LastName:FirstName+MiddleName+LastName

    Got it

  • Raunak Jhawar

    SSCoach

    Points: 15701

    December 17, 2013 at 1:42 am

    #1673971

    You forgot to add a space delimiter between names 😉

    Regards/Raunak
    Now a member of Linkedin

    Please visit the all new Performance Point Forum
    Please visit the all new Data Mining and Business Analytics Forum

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

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