Simple question on ASP

<i><b>Originally posted by : Jesse (jpatricio_2000@yahoo.com)</b></i><br /><br />Why can't i query a value of "A&W" on ASP?<br /><br />using for example:<br /><br /><a href="list.asp?ID=A&W"><br /><br />data connection here....<br /><br />strsql = "select * from table where ID='" & id & "';"<br />set rs = conn.execute(strsql) ''got error here<br /><br />but when the value is AAA it works fine.<br /><br />how can I replace the "&" character??<br /><br />thanks.

<i><b>Originally posted by : </b></i><br />Use URLEncoding method while passing values in querystring<br /><br /><br />------------<br />Jesse at 2/28/2002 9:16:55 PM<br /><br /><br />Why can't i query a value of "A&W" on ASP?<br /><br />using for example:<br /><br /><a href="list.asp?ID=A&W"><br /><br />data connection here....<br /><br />strsql = "select * from table where ID='" & id & "';"<br />set rs = conn.execute(strsql) ''got error here<br /><br />but when the value is AAA it works fine.<br /><br />how can I replace the "&" character??<br /><br />thanks.