ANSI Compliance
This is ANSI SQL:2011 compliant.
As an extension to ANSI, CAST permits the use of data attribute phrases such as FORMAT.
Syntax
CAST ( UDT_expression AS byte_data_type )
Syntax Elements
- UDT_expression
- An expression that results in a UDT data type.
- byte_data_type
- The BLOB, BYTE or VARBYTE byte type followed by optional FORMAT, NAMED, or TITLE attribute phrases to which UDT_expression is to be converted.