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 DECIMAL(10,2):
SELECT SUM (CAST (sales AS DECIMAL(10,2))) FROM euro_sales_table;