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.
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:
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 |