Subject sp case statement
Author Matchey,Brian
Is there a way to achieve the logic I'm trying to accomplish with the CASE statement in the WHERE clause below?



CREATE OR ALTER PROCEDURE GET_DATA (
Input_code char(1) )
RETURNS (
Output_code integer )
as
begin
FOR SELECT T.Output_code
FROM Table T
WHERE T.Input_code =
case :Input_code when 'A' then 'A'
when 'B' then 'B'
else (('A') or ('B'))
end
INTO :Output_code
DO
SUSPEND;
end;




Vertafore
Unleash your potential

Daniel Raith
Software Engineer II
26550 W. Mondovi St, Eleva, WI 54738
T 800 433 2550 Ext 2917 | F 805 553 9308 | draith@...<mailto:draith@...>
vertafore.com



[Non-text portions of this message have been removed]