Hallo Thomas, this is exactly what I need. Thanks. Works fine. Andre ________________________________
Von: Thomas Fischer [mailto:[EMAIL PROTECTED] Gesendet: Di 25.3.2008 18:10 An: Apache Torque Users List Betreff: RE: convert/cast sql expression 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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
