Double quotes in string problem

<i><b>Originally posted by : Danny (dcarva@texas.net)</b></i><br />Hi,<br /><br />Whenever I insert a string, that contains a double quote, into an SQL7 database, it cuts off the rest of the string after the double quote.<br /><br />Ex string to insert: <br /> This is a test " ok?<br /><br />Ends up in dbase as:<br /> This is a test <br /><br />I still want the double quote in there. Also, I really don't want to replace the double quote with two single quotes.<br /><br />Any help is greatly appreciated!

<i><b>Originally posted by : moz (jgraham@wilcom.com.au)</b></i><br />Replace the double quote with two double quotes<br /><br />e.g. select "this is a test "" ok "<br /><br /><br />------------<br />Danny at 2/10/2001 11:31:04 PM<br /><br />Hi,<br /><br />Whenever I insert a string, that contains a double quote, into an SQL7 database, it cuts off the rest of the string after the double quote.<br /><br />Ex string to insert: <br /> This is a test " ok?<br /><br />Ends up in dbase as:<br /> This is a test <br /><br />I still want the double quote in there. Also, I really don't want to replace the double quote with two single quotes.<br /><br />Any help is greatly appreciated!

<i><b>Originally posted by : Danny (dcarva@texas.net)</b></i><br />Thank you very much!<br /><br /><br />------------<br />moz at 2/13/2001 6:37:01 PM<br /><br />Replace the double quote with two double quotes<br /><br />e.g. select "this is a test "" ok "<br /><br /><br />------------<br />Danny at 2/10/2001 11:31:04 PM<br /><br />Hi,<br /><br />Whenever I insert a string, that contains a double quote, into an SQL7 database, it cuts off the rest of the string after the double quote.<br /><br />Ex string to insert: <br /> This is a test " ok?<br /><br />Ends up in dbase as:<br /> This is a test <br /><br />I still want the double quote in there. Also, I really don't want to replace the double quote with two single quotes.<br /><br />Any help is greatly appreciated!