Simple decode problem makes me want to die
Date: 9 Jun 2003 08:46:51 -0700
Message-ID: <7b53de56.0306090746.3bcd8614_at_posting.google.com>
I'm getting a headache over a simple problem with decode.
select distinct t5.productline,
'R1500','H',
for <i>some</i> productlines, this statement always defaults to 'Y'.
Anyone ever had any problems like this?
For instance, if i select FR7 or ABB it still will pull the default
'Y' for this decode when it should pull H. If i select GE51 it will
decode properly to 'H'. I dont' understand why this would happen....
If i select * from partmaster where productline = 'FR7' it will still
decode(t5.productline,'501','H','WES','H','W501','H',
'ABB','H',
'CENTR','H',
'FR1','H',
'FR6','H',
'FR7','H',
'GE51','H',
'GE52C','H',
'GMS71','H',
'W501F','H',
'WRONG','WRONG',
'Y') "BLAH" from partmaster t5 where productline = 'FR7';
Frustrating....
for the record it's Oracle 8.0.6 (I know we should upgrade) Received on Mon Jun 09 2003 - 17:46:51 CEST