Hey guys -
I'm trying to write a stored procedure / function in SS2k5. I have a pattern that i'm trying to match out of my input string. I have the regular expression written for it - but I just need to get the starting index of my search string from my regular/input string.
I can't use regex stuff that requires CLR to process- this all needs to be purely done in sql.
I've found out that PATINDEX can't take in regular expressions - but that in theory is what i'm trying to do....