January 31, 2002 at 8:47 am
Hi All,
first i want to perform a check on column whether if its null or not null. Then i want to check the next column for not null and null condition and then concatenate those values. How I should go about doing this. Right now I'm using CASE but I cannot seem to concatenate the output.
Something like this:
SELECT 'case_one' =
CASE WHEN col_one IS NOT NULL THEN col_one ELSE 'column one is null' +','
when col_two is not null then col_two
else 'column two is null'
end
FROM TABLE_NAME
The output I want is: col_one_value,col_one,col_two_value,col_two
Thanks!
January 31, 2002 at 7:49 pm
The simplest way is to break this into two separate CASE statements and concatenate the strings:
SELECT
CASE
WHEN col_one IS NOT NULL THEN col_one
ELSE 'column one is null'
END
+ ',' +
CASE
WHEN col_two IS NOT NULL THEN col_two
ELSE 'column two is NULL'
END
FROM TABLE_NAME
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy