Database delete issue
<p>I have this type of data stored as the BookMark in the BookMarks table.....this type of data (which is having ' in between the string) is not removed from the database....
Else other data are properly removed.</p>

<p>Then what is the solution of this type of issue.</p>

<p><strong>Query</strong>:--></p>

<pre><code>       Delete from BookMarks where name='Bimbo's 365 Club'

       Delete from BookMarks where name='Slim's'
</code></pre>

<p><strong>it gives me</strong>:--> </p>

<pre><code>       near "s": syntax error
</code></pre>

<p>Both of the above are the examples where problem occurs.</p>

<p>Please suggest me the appropriate solution of this issue.</p>
