williams.frd (5/8/2012)
Am I out of line in thinking this is something that should be handled in a high-level object-oriented language?
Hello. I am going to say "yes", but I am not being flippant about it ;-). Here are my two reasons:
1) SQL already includes similar albeit less functional equivalents in the form of: LIKE, PATINDEX, SUBSTRING, and REPLACE.
2) In terms of using Regular Expressions in WHERE clauses, this is something that SHOULD be in the DB layer as pulling back hundreds of thousands of rows to the app just to do filtering there is rather inefficient.
Take care,
Solomon...
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR