<div>
It would be something like: 
 
 
select 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;case when [type] = 'closed' 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;then (select Name+account+code+[TYPE]) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;else (select Name+account+code+[TYPE]+detail) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;end as col1 
from tbl1
</div>

It would be something like:


select
      case when [type] = 'closed'
                  then (select Name+account+code+[TYPE])
                  else (select Name+account+code+[TYPE]+detail)
             end as col1
from tbl1

<div>
Darn...&quot;close&quot; not closed so once again - sorry: 
 
 
select 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;case when [type] = 'close' 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;then (select Name+'-'+cast(account as sysname)+'-'+code+'-'+[TYPE]) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;else (select Name+'-'+cast(account as sysname)+'-'+code+'-'+[TYPE]+'-'+detail) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;end as col1 
from tbl1
</div>

Darn..."close" not closed so once again - sorry:


select
      case when [type] = 'close'
                  then (select Name+'-'+cast(account as sysname)+'-'+code+'-'+[TYPE])
                  else (select Name+'-'+cast(account as sysname)+'-'+code+'-'+[TYPE]+'-'+detail)
             end as col1
from tbl1

<div>
<div class="content wysiwyg-content">
I have a table tbl1 
 
Name | account code | Type &nbsp;| detail 
----------------------------------------------------------------- 
P1 &nbsp; &nbsp; &nbsp; | 12345 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| Open | detail1 
P2 &nbsp; &nbsp; &nbsp; | 12341 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| 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?
</div>
</div>

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?

SQL - How to concatenate a string with condition

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.