The problem is that when using a decode statement the search seems to have
to be specific i.e. 1,2,etc. I am searching on the fact that a contract ends
with M,H,Q,Y and the result will depend upon only the ending .
I have entered the decode statement :-
decode((Contract),'%Q',(Line*4),'%M', (Line*12),'%H',
(Line*2),'%Y',(Line),0)
I get results all of the default 0
I have also tried %'M' and Like '%M'
I have checked the company's Oracle SQL training manuals, specific cases are
all that are covered.
The only other time that I have used decode is when the search is specific
but this has now got me baffled
Comments and suggestions greatly appreciated
Thanks
J
Received on Fri Jul 02 1999 - 05:21:29 CDT
