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/


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.