DECLARE @str NVARCHAR(100) SET @str = 'Naveen2...

2011-03-10T23:53:21.791+05:30

DECLARE @str NVARCHAR(100)
SET @str = 'Naveen234Banda678Naveen587'
DECLARE @ptr INT
DECLARE @len INT
DECLARE @cnt INT
SET @ptr = 0
SET @len = LEN(@str)
DECLARE @result NVARCHAR(100)
SET @result = ''
WHILE CHARINDEX('Naveen',@str) <> 0 AND @ptr < @len
BEGIN
IF @ptr > 0
BEGIN
SET @result = @result+';'
END
SET @ptr = CHARINDEX('Naveen',@str) + LEN('Naveen')
SET @cnt = 0
WHILE (ISNUMERIC(SUBSTRING(@str,@ptr,1)) = 1)
BEGIN
SET @result = @result + SUBSTRING(@str,@ptr,1)
SET @ptr = @ptr + 1
SET @cnt = @cnt + 1
END
SET @str = SUBSTRING(@str,@ptr, LEN(@str) - @ptr + 1)
END
SELECT @result

Comments on Kiran Banda: String.Find(..., pattern) in SQL server 2005 or ab...

DECLARE @str NVARCHAR(100) SET @str = 'Naveen2...