RE: String to integer in SQL similar to atoi()

["Dennis Lovelady" <iseries@xxxxxxxxxxxx>]

> I think you statement should be something like this:
> *********
> Select
>    CAST(
>      SUBSTR(foocol, 1, POSITION(' ' in foocol) - 1)
>       AS Numeric(12, 0)
>        ) as N1,
>
>    CAST(
>      SUBSTR(foocol, POSITION(' ' in foocol) + 1)
>       AS Numeric(12, 0)
>        ) as N2
>   FROM footab
> *********

I never said "Thank you!" (yet).  Thanks for all who helped!  :)

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"I am not young enough to know everything."
        -- Oscar Wilde