Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## Character-string literals

> A character-string literal is a string of characters enclosed in single quotation marks ( '`` '). To include a single quotation mark in a character-string literal, precede it with an additional single quotation mark.

> Example

> The `INSERT` statements in the following example show embedding quotation marks in character-string literals:

>     insert into quote values('unquoted literal');
>     insert into quote values('''single-quoted literal''');
>     insert into quote values('"double-quoted literal"');
>     insert into quote values('O''Hare');select * from quote;

>     c1
>     --
>     unquoted literal
>     'single-quoted literal'
>     "double-quoted literal"
>     O’Hare

>     4 records selected

> Note: A character string literal can contain multi-byte characters in the character set used by the SQL client. Only single-byte ASCII-encoded quote marks are valid in the syntax.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095