Consider the following table definition, where euro is a UDT:
CREATE TABLE euro_sales_table (quarter INTEGER ,region VARCHAR(20) ,sales euro );
Assuming an appropriate cast definition exists for the euro UDT, the following statement converts the values in the sales column to CHAR(10):
SELECT region, CAST (sales AS CHAR(10)) FROM euro_sales_table WHERE quarter = 1;