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

[Bill <brobins3d@xxxxxxxxx>]

Dennis Lovelady wrote:
> > *********
> > Select
> >    Substr(foocol, 1, position(' ', foocol) - 1) as N1,
> >    Substr(foocol, position(' ', foocol) + 1) as N2 FROM footab
> > *********
>
> Having said that, on V5R3 the statement's choking on the comma within
> position( , ).  I suspect that position is not a function defined in V5R3.


Locate, Position and PosStr are all in V5R2, so there's something wrong 
with your statement.

Bill