To make it easier, the first thing I would do is do a replace any white space on the string:
select @var = 'ABC, CDG, DGT'
select @var = replace(@var, ', ', ',')
So now you have: 'ABC,CDG,DGT'
This will get you started:
while patindex('%,%', @var ) != 0
begin
print left(@var , patindex('%,%', @var) - 1))
select @var = right(@var, len(@var)-patindex('%,%',(@var))
end
print @var
Craig