Re: Is UNION supported on a VIEW in V5R1?

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