RegEx in MS SQL 2000?

Last Post 15 Mar 2010 02:35 PM by gunneyk. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Balance
New Member
New Member

--
26 Feb 2010 01:17 PM
Hello,

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.

TIA
gunneyk
New Member
New Member

--
15 Mar 2010 02: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.
You are not authorized to post a reply.

Acceptable Use Policy