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