split data in a single row into multiple records

I need to split a comma separated field into multiple records based on ‘,’

Answer

Youll want to use string_split like this:

select t.S.No, x.Value
from yourTable t
CROSS APPLY  string_split(Char, ',') x