Converts numeric data to UDT data.
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 ( numeric_expression AS UDT_data_type )
Syntax Elements
- numeric_expression
- A numeric expression to be cast to a UDT.
- UDT_data_type
The UDT type, followed by any FORMAT, NAMED or TITLE data attribute phrases, to which the expression is to be converted.