http://weblogs.asp.net/farhank/default.aspxenCommunityServer 2007 SP1 (Debug Build: 20510.895)http://weblogs.asp.net/farhank/archive/2008/07/04/creating-clr-sql-user-defined-function-to-validate-values-using-regular-expression.aspx#6357954Fri, 04 Jul 2008 13:02:28 GMTc06e2b9d-981a-45b4-a55f-ab0d8bbfdc1c:6357954Richard<p>You can simplify your function by replacing:</p> <p>Regex ObjRegx = new Regex((string) pattern);</p> <p>Match ObjMatch = ObjRegx.Match((string) value);</p> <p>return (SqlBoolean)ObjMatch.Success;</p> <p>with:</p> <p>return (SqlBoolean)Regex.IsMatch((string)value, (string)pattern);</p> <img src="http://weblogs.asp.net/aggbug.aspx?PostID=6357954" width="1" height="1">