Re: sql help-select sum of 2 fields in flat file

Don't know if this will work, but first thought:

select * from ardtl where cast(substr(F00001,22,5) as decimal (10,2)) = 156.79

If you can tell SQL that the substring is a number, you can compare it to a
number.

Assuming the above, this might work also (your question):

select sum(cast(substr(F00001,22,5) as decimal (10,2))) from ardtl where...

and

select sum( cast(substr(F00001,22,5) as decimal (10,2)) +
cast(substr(F00001,27,5) as decimal (10,2)) ) from ardtl where...

HTH,
Loyd

On Sat, 12 Jan 2002 17:06:50 -0500, "Jim Franz" <franz400@triad.rr.com> wrote:

>Trying to select data from flat s36 file (and that is working)
>dynamically building string (rpgsql)
>select from ardtl where substr(F00001,22,5) = x'000015679F'
>the 22,5 is a packed field in the flat file
>
>now need to select based on the sum of 2 packed fields in a record.
>(ar invoice amt + ar paid).
>How do I build a select based on sum of 2 fields.
>Every sql book & tutorial i see is to "simple" for this.

--
"Why, you can even hear yourself think." --Hobbes
"This is making me nervous. Let's go in." --Calvin
loyd@blackrobes.net  ICQ#504581  http://www.blackrobes.net/