I have not quite accustomed yet.

There is a table with repeating names.

From this table have chosen only unique names.

These names make set (group) of names.

This group is broken (divided(shared)) on...

select rtrim(ltrim(replace(replace('z z',' ',''),' ','')))

zz Instead of z z

One and too

select replace(convert(varchar(8),cast('2009-09-01 00:00:00.000'as datetime),5),'-','');

Thanks Lynn