The following statement creates a table that defines a euro column named sales :
CREATE TABLE swiss_sales (location address ,sales euro);
The following statement uses CAST to return a euro UDT expression. Using CAST requires a cast definition that converts the DECIMAL(8,2) predefined type to a euro type.
INSERT INTO swiss_sales SELECT location, CAST (sales AS euro) FROM european_sales WHERE region = 1038;