• 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.