harsha.bhagat1 (9/1/2008)
So now if I want the substring to work the way i want do you have an idea to solve this.. as this thing is eating my head now...I am stuck into this problem from last week..
Harsha, there might just be a solution here http://www.sqlservercentral.com/Forums/Topic560267-8-1.aspx
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden