Running DB2 on Power7.
I am attempting to perform a simple concat in a case statement that would combine a Pack with a Retail where Pack not equal to Zero.
Pack Retail NewRet
6 2.99 6/2.99
select case when FIELD1 <> 0 then FIELD1 || '/' || FIELD2
else FIELD2 END as NewRet,
I have tried multiple variations and failing every time. I am missing something, but what?....