RegEx in MS SQL 2000?

Last Post 15 Mar 2010 01:35 PM by gunneyk. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

26 Feb 2010 12:17 PM

I have to validate data for a specific column using a RegEx.
Is this possible at all with MS SQL 2000? I know, I know, MS SQL 2005 and above support RegEx's, but I'm running MS SQL 2000.

New Member
New Member

15 Mar 2010 01:35 PM
Regex is a CLR function that is not supported directly by the 2000 engine. You can however update the data using an external program that issues the update statement with the finial value.

Acceptable Use Policy