I am trying to pull a column from a SQL DB then check each record against a regular expression. If it matches then I need to break down the match into 3 variables. Below is my code is ASP, can someone help converting to ASP.NET? NOTE: It doesn&#039;t have to be a function but that would be preferable. TIA<BR><BR><BR>&#060;%<BR>Function theSuperFriends(theItem)<BR> Dim varLeft, varMiddle, varRight, myRegExp, Matches, aMatch<BR> Set myRegExp = New regexp<BR> myRegExp.Pattern = "[0-9]{5}-[0-9]{1}-[0-9]{3}" myRegExp.Global = True<BR> myRegExp.IgnoreCase = True<BR> Matches = myRegExp.Test(theItem)<BR> if Matches = "True" then<BR> theItem = right(theItem, 11)<BR> varleft = left(theItem, 5)<BR> varMiddle = left(right(theItem, 5), 1)<BR> varRight = right(theItem, 3)<BR> Response.Write(varLeft & "-" & varMiddle & "-" & varRight & "&#060;br /&#062;")<BR> end if<BR> Set myRegExp = Nothing<BR>End Function<BR>%&#062;<BR><BR>&#060;%<BR> Dim RS, oConn, sSQL, theItem<BR> set RS = server.createobject("ADODB.Recordset")<BR> set oConn = server.CreateObject("ADODB.Connection")<BR> sSQL = "SELECT * FROM TABLE WHERE COLUMN LIKE &#039;AAAA%&#039; ORDER BY COLUMN"<BR> oConn.ConnectionTimeout = 60<BR> oConn.Open ("Provider=SQLOLEDB;Data Source=SQLserver;Initial Catalog=ABCDE;User ID=someguy;Password=someword;")<BR> oConn.CursorLocation = 3<BR> RS.Open sSQL, oConn<BR>%&#062;<BR><BR>&#060;% do while not RS.EOF<BR> theItem = RS("COLUMN")<BR> call theSuperFriends(theItem) <BR> RS.MoveNext<BR> Loop<BR>%&#062;<BR><BR>&#060;% <BR> RS.Close<BR> Set RS = Nothing<BR> Set oConn = Nothing<BR>%&#062;<BR>