Consider the following table definition, where image is a UDT:
CREATE TABLE history (id INTEGER ,information image );
Assuming an appropriate cast definition exists for the image UDT, the following statement converts the values in the information column to BYTE:
SELECT CAST (information AS BYTE(20)) FROM history WHERE id = 100121;