Re: CASE in where statement. BUG ??

Richard Huxton wrote:
> On Friday 19 December 2003 09:02, Marek Lewczuk wrote:
>
> But until it's evaluated ''<>'' it doesn't know it is false. When building the
> CASE expression, it's trying to map types to each elements and notes that ''
> is not an int. Only after this stage will it actually try to evaluate the
> expression.
>

Well, I must say that it is wird action... Why to check both elements of
CASE expression, if we know for sure that only one will be executed ?