Hi if there case one. when coma is exactly after two character .

declare @t table(c varchar(100))

insert @t values ('AA,BB,CC'),('DD,EE,FF'),('GG,HH,II')

select

col1 = SUBSTRING(c,1,2),

col2 = SUBSTRING(c,4,2),

col3 = SUBSTRING(c,7,2)

from

@t

-------2

if there is no rule when coma will be there then write 3 split function which return

first return first part when string is passed ie -if we passed 'aaa,bb,cc' --- will return - 'aaa'

second return second part when string is passed ie -if we passed 'aaa,bb,cc' --- will return - 'bb'

third return third part when string is passed ie -if we passed 'aaa,bb,cc' --- will return - 'cc'

---