convert/cast sql expression

[Andre Steinmetzger]

Hallo I`m using torque 3.2 and search for a methode to create a convert or cast 
expression in the final sql. The target database is DB2. I hope somebody can 
help me. 
 
e.g. The column plz is a character datatyp and I like to use something like 
that:
 
        select * from dim.region where integer(dim.region.plz) between 10000 
and 12000
 
Thanks. Andre