Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
paritosh
Starting Member
42 Posts |
 Posted - 2012-08-17 : 01:24:17
|
| HI ALLI HAVE STRING SUPPOSESTRING :-AD675498IJU76I WANT TO SEPARATE WITH HYPHEN (-)BUT EVERY TIME POSITION IS NOT FIX.ASSUME FIRST TIME POSITION IS :- 4THEN RESULT : -AD67-5498IJU76ASSUME NEXT TIME POSITION IS :- 4,6THEN RESULT : -AD67-54-98IJU76ASSUME NEXT TIME POSITION IS :- 4,7THEN RESULT : -AD67-549-8IJU76I WANT TO DYANAMIC QUERY FOR SOLVE THIS PROBLEMTHANKS IN ADVANCE. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|
|
separate with hyphen to string again