Progress
SQL-89
Guide and Reference


Literals

Literals are constants. Literals can be character string, numeric, date, or logical data.

A character string literal can consist of non-numeric or character data, or a combination of numeric and non-numeric data. You must enclose character string literals in either single quotation marks (’ ’) or double quotation marks (" "), as shown in the following examples.

’Jane Smith’  "$125.00"  ’01754’  "15 Oak St." 

To include a single or double quotation mark within a character string literal, either enter the mark twice or use the opposite mark. For example:

’Brown’’s Plumbing Supply’  or   "Brown’s Plumbing Supply" 

Date literals require the format mm/dd/yy. For example: 09/13/57.

Logical literals are represented by yes/no or true/false.

The backslash (\) is a Progress escape character. To specify a backslash in a string literal, use a double backslash (\\).

Progress/SQL provides two wildcard characters that you can use in LIKE clauses to match character strings. The percent sign (%) matches zero or more characters. The underscore ( _ ) matches any single character.


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