I'm trying to use URLEncode to eliminate spaces when it pulls out a field name from a database that is displayed as a link. The link points to a file. Some of the files have spaces in their names. Here's my code. How can I utilize the urlEncode to take out the spaces from the <%=RS("FileName")%> in the code below?

<%
Set MyConn = Server.CreateObject("ADODB.Connection")
MyConn.Open "FILEDSN=C:\Program Files\Common Files\ODBC\Data Sources\jcaho.dsn"
%>
<%
SQL_query = "(SELECT * FROM JUpdate where ArticleType = 'JCAHO Update') "


Set RS = MyConn.Execute(SQL_query)

WHILE NOT RS.EOF
%>

<LI> <A HREF=<%=RS("FileName")%>> <%=RS("DateSubmit")%>: <%=RS("ArticleTitle")%> </A>
<%

RS.MoveNext
WEND

%>
<%
RS.Close
MyConn.Close

set RS=nothing
set MyConn=nothing



%>

Thanks!