Re: Convert hex string to integer (bigint) in SQL..

Yeah, that's certain an option.  I know there's a MI function that
does the conversion.

Was hoping I was missing something that already existed.

Charles

On Fri, Feb 26, 2010 at 10:14 AM, sjl <sjl_abc@xxxxxxxxxxx> wrote:

Charles -

I'm not sure about doing it with SQL, but I wrote an RPGIV program
a few years ago that takes a hex string and computes the number from it.

It would be easy enough to build a UDF to do what you want...
- sjl



Charles wrote:
All,

SQL offers the HEX() function to convert a value to a hexadecimal
string representation.

Is there a function that goes the other way, takes the hexadecimal
string representation back to an integer (or bigint)?



Thanks!
Charles


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.