No direct NUMERIC test, but you could use:
Runsql "select * from ItemMaster where translate(itemNbr,' ','1234567890') =
Probably not terribly efficient, but it does work!
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Stone, Joel
Sent: Tuesday, January 15, 2013 11:51 AM
Subject: SQL is numeric function
Does Iseries SQL have a numeric test?
Runsql 'select * from ItemMaster where itemNbr is not numeric'
This outbound email has been scanned for all viruses by the MessageLabs
For more information please visit http://www.symanteccloud.com