Re: Opposite of SQL DIGITS function

[Jromeh <Jromeh@xxxxxxx>]

Walden asked...

>    Is there a function that return a numeric value from character value. I
>have a char(6) field called FTE that contains "   4531" and I want the
>number 4531 from this, or more to the point I want FTE/100. Any ideas?

Don't know of a function that will do it directly, but it probably can be 
done with the HEX() function. Something like:

SELECT 'F' || SUBSTR(HEX(SUBSTR(FTE,1,1)),2,1)
    || 'F' || SUBSTR(HEX(SUBSTR(FTE,2,1)),2,1)
    || 'F' || SUBSTR(HEX(SUBSTR(FTE,3,1)),2,1)
    || 'F' || SUBSTR(HEX(SUBSTR(FTE,4,1)),2,1)
    || 'F' || SUBSTR(HEX(SUBSTR(FTE,5,1)),2,1)
    || 'F' || SUBSTR(HEX(SUBSTR(FTE,6,1)),2,1)

will return the needed string 'F0F0F4F5F3F1' -- please let us know if you 
find a way to get this into your 6/2 numeric field, no time to play with 
it now... <g>

HTH, 


/* -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- */
/* Jerome Hughes                        jromeh@aol.com                 */
/* InterPro Consulting Services         www.interproinc.com            */ 
/* Rosemont IL USA                      these are my own opinions only */
/* OMNI User Communications Director    www.omniuser.org               */
/* -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- */
People under time pressure don't work better; they just work faster.
-- DeMarco and Lister, Peopleware, Dorset House, 1987


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---