I tried inserting the following string "China, People's Republic of" using an INSERT INTO similar to this one:

INSERT INTO Table1 VALUES ('1', 'Test', 'China, People's Republic of')

but the (') and (,) interfere with the statement and I get an error message.

Can anyone tell me what I should use to qualify the value "China, People's Republic of" to make the statement work.

Hope this makes sense

I can't seem to find any help on the subject

Thanks in Advance

How you can't find help on this is beyond me, I tried "apostrophe sql" as a google search and the first result had the answer: http://www.google.co.uk/search?hl=en&q=apostrophe+sql

--

Joe (Microsoft MVP - XML)

Dom55,

'China, People's Republic of' - Wrong usage
'China, People''s Republic of' - Correct usage.

' - is used to enclose char/varchar/nvarchar/text/ntext/datetime values when used in sql statements. You should be taking care of negating the ' that appears within the values using another '.

Cheers

_________________________
- Vijay G
Strive for Perfection

replace (') with ('')

Thank you for the 3 replies. The solution you provided worked perfectly.

Thank you very much.

Domininc

another option

change
INSERT INTO Table1 VALUES ('1', 'Test', 'China, People's Republic of')
to
INSERT INTO Table1 VALUES ('1', 'Test', 'China, People''s Republic of')

but changing the people's with people''s it tells sql that it is data and not a field terminator.

The replace is done with two single quotes ('') and not one double quote (").