col1
---
M
S
S
Q
L
The expected Result is
Name
----
MSSQL
I need a single query which solves the above problem. please help me out?
Quote:
Originally Posted by Anu139
the table is
col1
---
M
S
S
Q
L
The expected Result is
Name
----
MSSQL
I need a single query which solves the above problem. please help me out?
hi all,
i got the answer for this.
declare @.name varchar(50)
select @.name = coalesce( @.name,'' )+ col1 from tab_name
select @.name 'Name'
