RE: SQL - Using Case in Where clause

["Bruce Guetzkow" <bruceg@xxxxxxxxxxxxxxxxxxxxxxx>]

How about without the case-statement:

     C/EXEC SQL
     C+ Declare cur1 cursor for
     C+  Select * from filea
     C+  Where (:Parm1 = '>'  and Field1 >  :testfield)
     C+     or (:Parm1 = '>=' and Field1 >= :testfield)
     C+     or (:Parm1 = '<=' and Field1 <= :testfield)
                        etc.
     C/END-EXEC


I couldn't test this, so I can't guarantee it...worth a try, though.

Hope this helps,
Bruce Guetzkow
Information Services Director
United Credit Service, Inc.
Phone: 262-723-2902
Fax: 262-723-5568
Email: bruceg@xxxxxxxxxxxxxxxxxxxxxxx
Web: www.unitedcreditservice.com