Hi All,
I have a string variable in sql and i want to split with multiple characters Delimiter .
DECLARE @STR = VARCHAR(100)
SET @STR = 'ABC***PQR***XYZ***FIRST NAME***MOBILE NO.'
and i want to result like this:-
Items:
ABC
PQR
XYZ
FIRST NAME
MOBILE NO.
Please Help....
Thanks in advance...