hi, I wrote the sp. but im getting the error as Msg 9411, Level 16, State 1, Procedure sp_delimiterexample1, Line 5 XML parsing: line 1, character 43, semicolon expected. here is my stored procedue..alter proc [dbo].[sp_delimiterexample1] @level_id varchar(50),@grp_id varchar(50)as SELECT F1.video_title, F1.video_drills, O.splitvideoFROM ( SELECT *,cast('<x>'+replace(F.video_drills,',','</x><x>')+'</x>' as XML) as xmlfilter from tns_course_mst F )F1 CROSS APPLY( SELECT video_drills.D.value('.','varchar(max)') as splitvideo FROM f1.xmlfilter.nodes('x') as video_drills(D)) O where level_id=@level_id and grp_id=@grp_id an anyone say where ui went wrong.