Luis Cazares (9/30/2013)
Just another possible solution.
SELECT *
FROM DelimitedSplit8K(@test, ' ') x
WHERE CHARINDEX( '@', x.Item) > 0
For the code of DelimitedSplit8K please read the following article:
🙂
--Jeff Moden
Change is inevitable... Change for the better is not.