RE: SQL Question.

It should be necessary to cast only one of ONTSHP or TOTSHP to make this work.

-------------- Original message -------------- 
From: "Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx> 

Alan, 

What are ONTSHP and TOTSHP, are the x.0 fields? If so, you're dividing 
an x.0 by and x.0 so you get an x.0. Then you case the x.0 to an 7.2, 
but by then it's too late. 

Try casting ONTSHP and TOTSHP each to a 7.2 before you do the division, 
and then cast the result to a 2.2 and you should get the right answer. 

-Walden 

-- 
Walden H Leverich III 
Tech Software 
(516) 627-3800 x3051 
WaldenL@xxxxxxxxxxxxxxx 
http://www.TechSoftInc.com 

Quiquid latine dictum sit altum viditur. 
(Whatever is said in Latin seems profound.) 

-- 
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list 
To post a message email: RPG400-L@xxxxxxxxxxxx 
To subscribe, unsubscribe, or change list options, 
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l 
or email: RPG400-L-request@xxxxxxxxxxxx 
Before posting, please take a moment to review the archives 
at http://archive.midrange.com/rpg400-l.