1
Reply

how to split 2 character in single column using sql server

Deepak Awashti

Deepak Awashti

Apr 7 2016 7:34 AM
265
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)