I am using Asp 2.0 and SQL 2000 along with VB 6. In one of the table in sql there is a value of "#" and "%", problem is how do i handle these special characters in my search criteria, cause everytime i build a multiple result page with all the values from the table with a hyperlink, application redirects itself to the page when user clicks on a link but does not bring in any values from the link that the user clicked on.
rajan