Progress
SQL-92
Guide and Reference
Delimited Identifiers
Delimited identifiers are strings of no more than 32 ASCII characters enclosed in double quotation marks ( “ ” ). Enclosing a name in double quotation marks preserves the case of the name and allows it to be a reserved word or to contain special characters. Special characters are any characters other than letters, digits, or the underscore character. Subsequent references to a delimited identifier must also use enclosing double quotation marks. To include a double quotation mark character in a delimited identifier, precede it with another double quotation mark.
NOTE: Although delimited identifiers preserve case for display purposes, case is still ignored for name matching. All of the following would refer to the same table: “Order”, “order”, Order, order. However, if the table were created using “Order”, it would display as written. With conventional identifiers, a table created as Order would display as ORDER.NOTE: This behavior differs from the SQL-92 standard, which requires delimited identifiers to be case-sensitive.The following SQL example shows some ways to create and refer to delimited identifiers:
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |