for some unfathomable reason, the html / asp pages I've written display the data from the hyperlink field on my Access 97 db as #mailto:username@domain" and is no longer a valid link

I have been told that I can parse out the #s on the asp page so that the "raw" link displays and will function correctly when clicked, but how do i do that?

Will appreciate any help on this matter.

Is it being stored with the pound in the database or is it being prepended somewhere else ? What language are you using in asp (vbscript) ?