How to split a string in Sql Server

DECLARE @Pos INT 
DECLARE @NextPos INT 
DECLARE @String VARCHAR(50) 
DECLARE @Delimiter VARCHAR(50) 
SET @String ='C-sharp,corner,.com' 
SET @Delimiter = ',' 
SET @String = @String + @Delimiter 
SET @Pos = charindex(@Delimiter,@String) 
WHILE (@pos <> 0) 
BEGIN 
SELECT	substring(@String,1,@Pos - 1) 
SET @String = substring(@String,@pos+1,len(@String)) 
SET @pos = charindex(@Delimiter,@String) 
END