Re: Re: how do you convert from hex to integer using SQL ?

Amazing indeed ! select '0xC'::integer from dual ; As I see it the magic is in the casting ! Chucho! -----Original Message----- From: Rajib Sarkar <rsarkar@us.ibm.com> To: darren.edgerton@reece.com.au Date: Wed, 5 Jan 2005 13:00:28 -0700 Subject: Re: how do you convert from hex to integer using SQL ? Its pretty simple actually ..:-) u can try something like: select '0xa' + 0 from systables where tabid = 1; It'll print the integer value of the hex. U can substitute ur column instead of the hard-coded value in the example. Thanx much, Rajib Sarkar Advisory Software Engineer DB2/UDB Regional Advanced Support IBM Data Management Group If we all did the things we are capable of doing, we would literally astound ourselves. -- T. Edison darren.edgerton@r eece.com.au Sent by: To owner-informix-li informix-list@iiug.org st@iiug.org cc Subject 01/05/2005 12:09 how do you convert from hex to AM integer using SQL ? Please respond to darren.edgerton Hi, i need to conv from Hex to Integer can this be done using SQL with Informix ?? ie select integer(hex_data_column) from mytable thanks, DSE Jean Sagi jeansagi@myrealbox.com jeansagi@yahoo.com sending to informix-list