Converts a UDT expression to a different UDT type.
ANSI Compliance
This statement 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 UDT_data_type )
Syntax Elements
- UDT_expression
- An expression that results in a UDT data type.
- UDT_data_type
The UDT type, followed by any FORMAT, NAMED or TITLE data attribute phrases, to which the expression is to be converted.