|
I've replace the UNION with a CASE. It's much prettier this way anyway. However I have the following: ... CASE When IREF02=' ' Then 0 When substr(IREF02,1,1) BETWEEN 'A' AND 'Z' Then 0 Else CAST(iref02 as dec(7,2)) End as Iref02Nbr, ... However if IREF02='10CER' My SELECT statement gives all plus signs for Iref02Nbr. I thought that maybe it was a null. So I tried SELECT iref02, coalesce(iref02nbr,0) FROM CLIPERF/IIML88 where iref02='10CER' However, I still got the plus signs. Any suggestions? Like is there a bullshirt(x,y) function much like the coalesce function? I am like, this close, to using a UDF for simple number conversion. Rob Berendt -- "They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." Benjamin Franklin
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.