symbol retreived via database causes asp page to fail

<i><b>Originally posted by : </b></i><br />This is to do with WAP (WML) but the asp database retreval is giving me the problem:- <br /><br />Using ASP, the NAME field is pulled from a database and some NAME fields are called "Windsor 'A' "<br />The ' needs to be replaced before the wml is processed.<br /><br />I have tried replacing: -<br /><br />oRSc("NAME") below within the option WITH server.HTMLEncode (oRSc(NAME))<br />But still the ' is shown the and wml fails. <br /><br />Please can someone help me by modifiying the below code to work even though ' is sometimes contained within the NAME part of database.<br /><br />PS I don't care if the ' is deleted or replaced with a space as long as the rest of the field is visable (ie. "Windsor 'A' " could become "WINDSOR A " on the wap display)<br /><br />I have spend a few weeks trying to sort this out but as I am an complete amature, trial and error is really causing me a headache.<br /><br /><br />********** PART OF ASP CODE:- ***************<br /><br />do while not oRSc.eof<br /> <br /><br /> Response.Write "<option value='" & oRSc("NAME") & "'>" & _<br /> oRSc("NAME") &_<br /> "</option>"<br /> oRSc.MoveNext<br /> loop<br /> <br />oRSc.Close<br />set oRSc = nothing <br /><br />************************************************<br />