GenericOLEDB - how to insert string var with single quote in value?

[rick at abc]

Using the sample GenericOLEDB how can you insert a string that has a single quote in the text of a string var? insert into SOMETABLE ([SOMEFIELD]) VALUES ('Bob's');

[Luc Pattyn]

Google SQL literal string, to find the documentation[^]: When SET QUOTED_IDENTIFIER is ON, identifiers can be delimited by double quotation marks, and literals must be delimited by single quotation marks. When SET QUOTED_IDENTIFIER is OFF, identifiers cannot be quoted and must follow all Transact-SQL rules for identifiers. For more information, see Identifiers. Literals can be delimited by either single or double quotation marks. And of course, if the SQL statement is itself a string literal (e.g. in C#) then you must escape all double quotes with a preceding backslash. :)

Luc Pattyn

---

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

---

[i j russell]

insert into SOMETABLE ([SOMEFIELD]) VALUES ('Bob''s'); Two single quotes '' not a double quote ".

[Niladri_Biswas]

Try this

declare @tbl table(SomeField varchar(50))
insert into @tbl(SomeField) values('Bob''s')
select * from @tbl

Output: SomeField

Bob's

Instead of 'Bob's' write 'Bob'**'**s'. Hope this helps :)

Niladri Biswas