title: in select statement how we compare a string field which contain single quotes
body: <p>i have a filed in stock table with title product. when i use the following statement </p>
  
  <blockquote>
    <p>rs.Open  "select * from stock where product='" &amp; product_name &amp; "'
    ",db,2,1</p>
    
    <p>id = rs!sub_head_id</p>
    
    <p>rs.Close</p>
  </blockquote>
  
  <p>where product_name is string variable which contain a product name</p>
  
  <p>for example:</p>
  
  <blockquote>
    <p>product_name="alpha's cell"</p>
  </blockquote>
  
  <p>this  statement make an error, because of single quotes in string.
  how we resolve this</p>
  
  <p>note: i am using vb6</p>