Re: LIKE clause

Note that you may get better performance by removing the case statement. Something like;
and (param1 = 3

   or (then param1 = 1 and fl.status like '%NBH%')    or (then param1 = 2 and fl.status like '%SVH%') )

If as you said, you don't need to lookup the value of fl.status when param1 is 3. Received on Tue Jul 18 2006 - 06:54:26 CDT