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

I think IDS directl'y can't do this, but you can do a stored procedure to do the conversion. I'm almost sure that a bladelete exist with a function like this. Chucho! -----Original Message----- From: darren.edgerton@reece.com.au To: informix-list@iiug.org Date: 4 Jan 2005 23:09:40 -0800 Subject: how do you convert from hex to integer using SQL ? 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