Deepak Awashti

Deepak Awashti

  • NA
  • 301
  • 74.1k

how to split 2 character in single column using sql server

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