Link to home
Start Free TrialLog in
Avatar of SQL Guru
SQL Guru

asked on

Split similar letter -SQL query

Hi Experts,

I try to think logically to write this procedure but couldn't think one. I want to the split similar occurrence of the letter from a column. How to do it?

Sample example
column
aaa#!RRR@R 
R#!AR###!

Open in new window


Required Output
OUTPUT
-aaa-#-RRR-@-R
-R-#-!-A-R-###-!

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Brian Crowe
Brian Crowe
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial