Handling Single Quotes in a SQL Query

To insert data with single quotes, place 2 single quotes instead of 1 single quote, like this:

 create table MyTable (    Field1 varchar(10))goinsert MyTable (Field1)    select 'A1111''1111' UNION ALL    select 'F''66666666'

In the same way, you can retrieve data by using 2 single quotes. For example:

 select * from Mytable where field1='F''66666666'select * from Mytable where field1='A1111''1111'drop table mytable
Share the Post:
Share on facebook
Share on twitter
Share on linkedin


Recent Articles: