You serious? MS SQL runs on UNIX? And how do you use BOURNE from inside T-SQL???
I use regex on my SQL box now, the pcre one from Code Project http://www.codeproject.com/database/xp_pcre.asp in triggers. Plus I can copy and paste regex from anywhere on the web. I think they're a lot easier than trying to shuttle data back and forth to a unix box every time I want to check a simple pattern. Wouldn't that slow everything down? Can you even do that from a trigger? I tried tsql stroed procs and udfs at first, but they get complicated real fast. What are the other options you talked about that are endless?
Thanks.