Progress
SQL-92
Guide and 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


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