RE: SQL selection problem

[rob@xxxxxxxxx]

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