Split function in sp sql server

How to use split function in SP..Bleow is my sp i need to split the value of complexion column where the value of complexion is (2,5,) in my table i need to split as 2 and 5 seperately...find any soln

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER proc [C244570_marriage].[sp_fillexpectation]
@CustomerId nvarchar(max)
as
begin
--select * from customerExpectation where CustomerId='d14a96ac-0527-41c6-9ecb-eaeb7545561e'
select * from  customerexpectation ce
left outer join familystatus fs on ce.familystatus1=fs.id
left outer join complexion cp on ce.complexion1=cp.id
left outer join familytype ft on ce.familytype1=ft.id
left outer join foodhabit fh on ce.foodhabits=fh.id
left outer join education e on ce.qualification=e.id

where  ce.CustomerId=@CustomerId
end

Tags: SQL Server 2005, SQL Server