Settings and activity
3 results found
-
53 votes
Vern Rabe
supported this idea
·
-
2 votes
An error occurred while saving the comment Vern Rabe
shared this idea
·
-
10 votesVern Rabe
supported this idea
·
Well, the comment format is not at all what I submitted. I'll try again:
SELECT CASE
WHEN COL = 1
THEN 'COL 1'
ELSE ''
END + CASE
WHEN COL = 2
THEN 'COL 2'
ELSE ''
END + CASE
WHEN COL = 3
THEN 'COL 3'
ELSE ''
END AS ConcatStr
FROM #Test;
What I'd like to get is:
SELECT CASE
WHEN COL = 1
THEN 'COL 1'
ELSE ''
END
+ CASE
WHEN COL = 2
THEN 'COL 2'
ELSE ''
END
+ CASE
WHEN COL = 3
THEN 'COL 3'
ELSE ''
END AS ConcatStr
FROM #Test