By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
with cte as (
select convert(varchar(max), null) as c, convert(varchar(max), 'Consultant') as rest, 0 as lev
union all
select left(rest, 1), stuff(rest, 1, 1, ''), lev + 1
from cte
where rest <> ''
)
select c, string_agg(lev, ',')
from cte
where lev > 0
group by c;
| c | (No column name) |
|---|---|
| a | 8 |
| C | 1 |
| l | 6 |
| n | 9,3 |
| o | 2 |
| s | 4 |
| t | 10,7 |
| u | 5 |