Hi All
I have a nvarchar(MAX) column (as below) in SQL table, I need to extract nth occurrences substring from this column; I manage to extract the 1st occurrence with CHARINDEX statement 10137-microsoft-technet-qa-roychen.pdfbut unable to extract 2nd, 3rd and 4th.....
Sample nvarchar (MAX) Column refer to attachment please.
Very Appreciate your kindness advice
Roy