Derived column question with ISNULL
-
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
-
ISNULL( MiddleName)? FirstName + LastName:FirstName+MiddleName+LastName
Got it
-
You forgot to add a space delimiter between names
Raunak J
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply