Need to remove # at the start and end of link address stored on database

[kevredphysics]

Hi
I am using asp and database to store info for example link addresses. Unfortunately, they have become stored in database column with a # on either side. I have tried find and replace but this does not work on # symbol. It can not be stored as a hyperlink because I need my website to extract info from remote database and then display info in results page as a hyperlink. Works fine if I remove them by hand but there are 3000 of them!
[eg #http://accessforums.net#]
Any ideas?
Kev

[pbaldy]

If they are always the first and last characters, this type of thing should work:

Mid(FieldName, 2, Len(FieldName) - 2)

[kevredphysics]

Hi
Where do I stick this programing? In my results page? What does it mean? Why a 2 and a -2?
Kev

[pbaldy]

It would work just about anywhere; in a SELECT or UPDATE query, in code, etc. As to what everything means, have you looked in help at the Mid() function?