Space problem in Hyperlink
I am using following query to retrieve the records.

ssql="SELECT contractno,recordno,REVERSE(LEFT(REVERSE(Imagerefe rence), CHARINDEX('\', REVERSE(Imagereference)) - 1)) imagereference FROM nonarc where contractno='"& contractno& "'"

set rs=cn.Execute(ssql)

Response.Write("<td>")
Response.Write("<a href=" & (rs("imagereference")) & ">" & rs("imagereference2") & "</a>")
Response.Write("</td>")


If
Imagereference=civil avilation.tif // space between file name it not display on click
Imagereference=airport area.tif
Imagereference=city area.tif
….

There is space between file name of drawings.
It not display, also not return full path of drawings.

How can display the drawings if file name with space ?
I have thousand of records to display.

Imagereference path is \\auhtripdc\as_built\nontrip\civil aviation.tif

It only show file:\\auhtripdc\as_built\nontrip\civil path in asp page.

How it will display full path ?

Please help

Mateen

I think it is a question of missing quotes, try this:
or this:

thanks a lot to point out the mistake