Dennis Cote wrote: > > The case you mentioned as a motivation can be handled using the > following expression. > > case > when :param is null then x is null > else x = :param > end >
I though I should also mention a somewhat simpler equivalent expression that can be used to replace the proposed IS operator expresion with a parameter x is :param => (:param is null and x is null) or x = :param This expresion can also be used anywhere the IS operator expresion can, and is clearer than the case expression I suggested earlier.
