query to find a sum of char values present in different rows

[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?

[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?

I got the answer

declare @name varchar(50)

select @name = coalesce( @name,'' )+ col1 from tab_name

select @name 'Name'