Not able to insert the text in sql query which has apostrophe

Yes, that is a problem many users of SQL face. Using an apostrophe in the code, requires a small and easy task. It needs to be done just as in the HTML code, which you code. You should replace each apostrophe with two, so that you can insert an apostrophe into the code.

For example if you want to insert an apostrophe into the code try the following:

Insert into foo (name) values ('duncan o''toole")

Cheers.

•   In SQL strings are enclosed within single quotes '.........' .  So if a string has an apostrophe within it, then it has to result to an error.

•     The solutions is to put two apostrophes in the string, as show below:

Or Using most of the programming language by replacing the single quotes with  a double qoute  by use of replace function. for example in vb.net  as shown below:

Thank you both for the help.