The ANSI standard allows two forms of CASE statements in stored procedures. While Sybase IQ allows both forms, if CASE is in the predicate, for best performance you must use the form shown in CASE statement in Sybase IQ Reference Manual.
If you require the other form (also called ANSI syntax) for compatibility with Adaptive Server Anywhere, see CASE statement Syntax 2 in Adaptive Server Anywhere SQL Reference.
