title: Single quote handling in a SQL string
body: <p>I have an application where the values in the text field are sent to the database.</p>
  
  <p>For example I have a form with one field (text box). When I press Ok button then the content of the text field is inserted as a record into a table. I'm just trimming and extracting the text box's text into variable and passing it to my SQL string.</p>
  
  <p>The problem is that whenever something like "It's" or "Friend's" the single quote is identified as the end of string. In Delphi I have seen something like <code>QuotedString</code> to avoide this. Any ideas from you?</p>