asked on SQL - How to concatenate a string with condition
I have a table tbl1
Name | account code | Type | detail
--------------------------
P1 | 12345 | Open | detail1
P2 | 12341 | Close |
I would like to do a Select that will selectively concatenate the information into a description if the information is available.
e.g
for first record
P1 - 12345 - Open (detail1)
but for second record, no detail being concatenated since it is not available.
P1 - 12341 - Close
How will I do that?
Name | account code | Type | detail
--------------------------
P1 | 12345 | Open | detail1
P2 | 12341 | Close |
I would like to do a Select that will selectively concatenate the information into a description if the information is available.
e.g
for first record
P1 - 12345 - Open (detail1)
but for second record, no detail being concatenated since it is not available.
P1 - 12341 - Close
How will I do that?
Microsoft SQL Server
Last Comment
tommym121
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Darn..."close" not closed so once again - sorry:
select
case when [type] = 'close'
then (select Name+'-'+cast(account as sysname)+'-'+code+'-'+[TYP
else (select Name+'-'+cast(account as sysname)+'-'+code+'-'+[TYP
end as col1
from tbl1
select
case when [type] = 'close'
then (select Name+'-'+cast(account as sysname)+'-'+code+'-'+[TYP
else (select Name+'-'+cast(account as sysname)+'-'+code+'-'+[TYP
end as col1
from tbl1
ASKER
Thanks
select
case when [type] = 'closed'
then (select Name+account+code+[TYPE])
else (select Name+account+code+[TYPE]+d
end as col1
from tbl1