|
Try again. Use DIGITS instead of DEC in case data is corrupted like the following. select * from qtemp/alan ....+....1....+ FIELDA FIELDB 12345 12,345 1 yhdfd 2 45678 9 26 26 030 30 250 250 ******** End o select * from qtemp/alan where fielda=' ' or (right('00000' concat trim(fielda), 5) =digits(fieldb)) ....+....1....+ FIELDA FIELDB 12345 12,345 1 26 26 030 30 250 250 ******** End of data You can add this if you like order by right('00000' concat trim(fielda), 5), fieldb // add fieldb in case two blank numbers with different digits. to get ....+....1....+ FIELDA FIELDB 1 26 26 030 30 250 250 12345 12,345 ******** End of data Rob Berendt
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.