Trying to find an easy way to tell if a field has numeric data. Other SQLs have a function like IsNumeric. Is there an equivalent in SQL/400?
Thanks.
Thanks.
WrkNum 6S 0 Inz
WrkNo 6 Inz
....
Monitor;
WorkNum = %Dec( %SubSt( InField : 1 : 6 ) : 6 : 0 );
On-Error;
WorkNo = %SubSt( InField : 1 : 6 );
EndMon;
Select Length(Trim(Translate(MyChar, ' ', '1234567890'))) as ChkDigits
from MyTable
Create Function MySchema/isNumeric (
ParAlpha VarChar(32))
Returns Integer
Language SQL
Deterministic
Reads SQL Data
Called on NULL Input
Disallow Parallel
Return Length(Trim(Translate(ParAlpha, ' ', '1234567890')));
Select MyFld, isNumeric(MyFld)
From MyTable
Comment