Joel,

Try this:

SELECT * FROM TEXTFILE WHERE TRANSLATE(TEXT, ' ',
'1234567890') = ' '

If the result is ' ', the field contains only numbers.

HTH,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries




Return to Archive home page | Return to MIDRANGE.COM home page