SQL string conversion

[Mark Lazarus <mlazarus@xxxxxxxx>]

 Is there a way to convert a string to a numeric in SQL/400?  I have a file
that is being uploaded from a PC.  The initial DB that it is being uploaded
to has a single field.  The area in the record is being pre-screened to
make sure it is numeric.

 What I wanted to do is something like this:  SELECT * WHERE VAL( SUBST(
DATA, 15, 7 ) ) > 100.  Or assign it to a numeric field an on update.  I
realize that there is no VAL function.  Is there an equivalent function or
workaround?

 -mark

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---