Retrieving ' symbols within database caused wap site to fail

<i><b>Originally posted by : matthew clark (mat_clark@ic24.net)</b></i><br />Hi, in my wap application, I am retreiving data from a database using asp. The database has ' symbol in the field that causes the page to fail as wml thinks this is the code, How can I get around this as the database can't be changed? <br /><br />I have tried michael wright article on "Validate your WAP pages with Wapalidate" but had no joy.<br /><br />http://www.aspfree.com/authors/michaelw/wap/wapalidate.asp<br /><br />The field I am reteiving is placed in option tag.<br />With this Waplidate function inserted<br />When looking at the source code sent to the wap emulator, the ' is still displayed and not replaced, causing the site to fail<br /><br />Any help appreciated<br /><br />Regards<br /><br />Matthew Clark<br />