Can Server.URLEncode Method Used On Sql 2005?

we have a search string is used Server.URLEncode Method in sql 2000, but since we moved database from server2000 to 2005 then ,this search string doesn't work. does some know it?????


the code is :

Public Function categories(strType, recID)
Dim objConn, objRS
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open strRGConnection
Set objRS = Server.CreateObject("ADODB.Recordset")
Set objRS.ActiveConnection = objConn
If strType = "product" Then
strQ = "SELECT category FROM productsCategories where prodID = " & CInt(prodID)
End If
If strType = "service" Then
strQ = "SELECT category FROM ServicesCategories where svcID = " & CInt(svcID)
End If
objRs.Open strQ
categories = ""
tempCategories = ""
firstRec = True
While not objRS.EOF
If NOT firstRec Then
tempCategories = tempCategories & ", "
End If

tempCategories = tempCategories & "<a href='/resourceguide/resources/searchResults.asp?category=" & server.URLEncode(replace(objRS("category"),"'", "''")) & "&searchSource=Browse'>" & objRS("category") & "</a>"
firstRec = False
objRS.MoveNext
Wend
categories = tempCategories
objRS.Close
objConn.Close
Set objRS = Nothing
Set objConn = Nothing
End Function