Seems like Criteria.CUSTOM is what you need. See
http://db.apache.org/torque/releases/torque-3.3
/runtime/reference/read-from-db.html
section "Using the CUSTOM modifier to use custom SQL"
Hope this helps,
Thomas
"Andre Steinmetzger" <[EMAIL PROTECTED]> schrieb am 25.03.2008
17:07:44:
> 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
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
