× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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 thread ...


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

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.