Lawrence,
Try something like decimal(float(1.9788283e-3),30,15)
David Morris
>>> Lawrence_Tuttle@eogresources.com 03/01/01 11:20AM >>>
I have the following alpha field (IntRate):
1.978283e-03
When I run an SQL statement DECIMAL( TRIM(IntRate),11,10) I get a Casting
error. Does anyone know of a scalar function that will convert this value.
+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---
+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---
