sap cost center report by month. . You could. This query should return something like 1, "john,mike,petra". . . ', ' '); Heres how the results look Splitting strings in SQL with the STRINGSPLIT function. Value --SplitData from yourtable cross apply STRINGSPLIT (Data, ',') cs All the other methods to split string like XML, Tally table, while loop, etc. Aug 02, 2019 &183; SQL server has provided on in built function which will directly convert the comma separated string in to rows format.