eliminating dashes in db fld to make a hyperlink

[rjkealey]

Hi All
I am havig a problem with a fld from my db that i want to take dashes out then convert to hyperlink

EX. fldParcelId from db = 0095262-228970-6

I need to take both dashes out to get this value
00952622289706

Which I then can stick on the end of a hyperlink

EX.

http://www.ccappraiser.com/GIS_instructions.asp?acct=00952622289706

any help would be greatly appreciated
RJKealey

 

[fattyfatpants]

Dim strFormatted

strFormatted = replace(fldParcelId, "-", "")

where fldParcelId is the database field you are accessing

 

[rjkealey]

FATTYFATPANTS
Thank for your help I really appreciate it and I got it working thanks to you here is what the outcome link looks like
**************************************************
<td>Property Appraisar Sheet :</td><td><a target="new" href="

http://www.ccappraiser.com/Show_parcel.asp?acct=<%=

strFldParcelId %>&gen=T&tax=T&bld=T&oth=T&sal=T&lnd=T&leg=T"><%= strFldParcelId %></a></td>
*************************************************

Thanks Again
RJKealey

 

[fattyfatpants]

Cool beans