Hi helpers, just a note to say thank you, to everyone who gave me hints, packages and func.s !!! Great maillist !!! TNX > Frank Foelz < _________________________________ Scheidt & Bachmann GmbH Gestaltung Parkhaussysteme Breite Strasse 132 41238 Moenchengladbach Phone : ++49 2166 / 266 - 837 Fax: ++49 2166 / 266 - 615 e-mail : mailto:[EMAIL PROTECTED] URL : http://www.scheidt-bachmann.de ________________________________________________________________________ -----Ursprüngliche Nachricht----- Von: Foelz.Frank [mailto:[EMAIL PROTECTED]] Gesendet am: Donnerstag, 8. Februar 2001 11:15 An: Multiple recipients of list ORACLE-L Betreff: Decimal to Hex conversion Hi everybody, I am facing a problem converting from decimal values to hexadecimal values. i.e. col1 col2 ---------- 2021 801 should give (2021*65536+801)=132449057 I am asked to present this value in hexView like : 07E50321 any suggestions howto convert (probably via simple SQL) ????? TNX > Frank Foelz < sorry, but I posted this to [EMAIL PROTECTED], already. We are facing problems with some mailservers today..... _________________________________ Scheidt & Bachmann GmbH Gestaltung Parkhaussysteme Breite Strasse 132 41238 Moenchengladbach Phone : ++49 2166 / 266 - 837 Fax: ++49 2166 / 266 - 615 e-mail : mailto:[EMAIL PROTECTED] URL : http://www.scheidt-bachmann.de ________________________________________________________________________ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Foelz.Frank INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Foelz.Frank INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).