|
|
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
Navigation:
[Reply to this message]
|