how do i insert a single quote in an access db through asp ps help required urgently

<i><b>Originally posted by : venkatesh krishnamurthy (venky33@hotmail.com)</b></i><br />1)how do i insert a single quote in an access db through asp ps help required urgently<br />2)how do i check for a single quote taken from an asp form do be inserted in an access database:<br />for eg. what's the question i give the answer's that is the single quote can appear randomly<br />3)how do i populate a text area(not text box)with record from access database using asp

<i><b>Originally posted by : Barry</b></i><br /><br /><br />Here is a function we use to insert, call or search in an access database. Just run all of your variables through this function and it does a replace. The trick is to use it in everything going into a database and for all searches to the data base.<br />Function CleanString(instring)<br /> mystring = instring<br /> TReplace = Replace(mystring,Chr(39),Chr(146))<br /> TReplace = Replace(TestReplace,Chr(34),Chr(148))<br /> TReplace = Replace(TestReplace,Chr(44),Chr(130))<br /> CleanString = TReplace<br />end function <br /><br />------------<br />venkatesh krishnamurthy at 4/8/2000 7:25:28 AM<br /><br />1)how do i insert a single quote in an access db through asp ps help required urgently<br />2)how do i check for a single quote taken from an asp form do be inserted in an access database:<br />for eg. what's the question i give the answer's that is the single quote can appear randomly<br />3)how do i populate a text area(not text box)with record from access database using asp