At 02:56 PM 5/10/99 +0200, you wrote:
>"Ken J. Wright" ha scritto:
>
>> You have to preceed each occurence of ' with a \.
>> So "test'string" becomes "test\'string".
>>
>
>SQL92 says that you have to use the ' twice. If you want to write portable
>code, then:
>
>INSERT INTO table1 VALUES('WHAT''S THAT ?');
>and it becomes: WHAT'S THAT ?.
But just to clarify further, that only works with sql. Copy needs the '\'
approach.
So many choices ;-)
Ken