Progress
SQL-92
Guide and Reference
CAST Function
Converts an expression to another data type. The first argument is the expression to be converted. The second argument is the target data type.
The length option for the data_type argument specifies the length for conversions to CHAR and VARCHAR data types. If omitted, the default is 1 byte.
If the expression evaluates to null, the result of the function is null. Specifying NULL with the CAST function is useful for set operations, such as UNION, that require two tables to have the same structure. CAST NULL allows you to specify a column of the correct data type, so a table with a similar structure to another, but with fewer columns, can be in a union operation with the other table.
The CAST function provides a data-type-conversion mechanism compatible with the SQL-92 standard.
Use the CONVERT function, enclosed in the ODBC escape clause { fn }, to specify ODBC-compliant syntax for data type conversion. See the ODBC compatible CONVERT function for more information.
SYNTAX
EXAMPLE
The following SQL example uses CAST to convert an integer field from a catalog table to a CHARACTER data type:
COMPATIBILITY
SQL-92 Compatible
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |