Hello sir, I could load data in single column in table. but I need to seperate comma

select empFirstName,len(empFirstName) - len(replace(empFirstName, ',', '')) as 'Noofcomma'

from [dbo].[test]

I can load data in three different table using where Noofcomma=2/3/4, but still I need to split those comma to load in final tables.

As you said, I try to use derived column but I do not know use.