|
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 mailing list archive is Copyright 1997-2024 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.