1
Answer

how to split 2 character in single column using sql server

how to split 2 character in single column using sql server
 
 
my column data is -----
 
'Atest1 0ÿBtest1 0ÿCtest1 0ÿDtest1 0ÿA 0ÿB 0ÿC 0;Atest1 0ÿBtest1 0ÿCtest1 0ÿDtest1 0' 
 
split character in ('0y' to ' ')
 
please help me its urgent 
Answers (1)