OR! CLR RegEx search...

If you download the codes for the DB Sambles from CodePlex...

There is code there already that exposes the RegEx search into SQL...

That is... if your allowed to...

Have you looked into Full Text Search?

I cant say I have had the pleasure of working with it... but if I recall correctly... it was designed for string searches...

LOL my bad... a little early in the morning for me 😀

DECLARE @doc NVARCHAR(MAX)

SET @doc ='

<NewsDTO>

<NewsList>

<NewsID>A4C13A4A-2350-4D21-AB06-9E2946182D39</NewsID>

</NewsList>

<NewsList>

<NewsID>A3613580-99C3-489D-9988-92E5F24BC8F7</NewsID>

...

Can you provide more details on what your trying to do?

I get what your code is doing but there are some logical issues with it...

The idea of you wanting to...

Rather than trying to muddle around with Air Code on a query like that... where the results of the Air Code is going to cause you more headaches than you...

How about something like this...

Its pretty straight forward and wouldn't require any extra functions.

(However, there are perks to the function spiting apart a string)

--Holds the Account Numbers

DECLARE