sql quotes

<i><b>Originally posted by : Ton (t.meulman@plant.nl)</b></i><br />I have made a form that posts a variable. I want to use that variable in a SQL query to do a database search, but I am having trouble with the right way to make the SQL string. I think this has to do with using the right quotes<br />can someone help me hare?

<i><b>Originally posted by : Eric Preston (ericpreston@email.com)</b></i><br />Without more info the most I can offer is, when querying a DB through SQL, if the field is TEXT then you need to use single quotes<br /><br />EX: WHERE TEXTFIELD='yourtext'<br /><br />If it's a numeric field then you don't use quotes<br /><br />EX: WHERE NUMERICFIELD=1<br /><br />If it's a MEMO field then you can't query it.<br /><br />Hope this helps<br /><br /><br />------------<br />Ton at 3/21/2002 3:05:00 PM<br /><br />I have made a form that posts a variable. I want to use that variable in a SQL query to do a database search, but I am having trouble with the right way to make the SQL string. I think this has to do with using the right quotes<br />can someone help me hare?