Posted by Erland Sommarskog on 06/20/05 10:20

Stu (stuart.ainsworth@gmail.com) writes:
> I agree; I wish SQL had a RegEx function to easily search for patterns
> and split it into smaller pieces. We have to maintain a syslog
> database for our clients, and it would be nice if I could chop that up
> into usable chunks on the fly, rather than through an import process.

Well in SQL2005 you can use the RegEx class in the CLR.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]