Re: SQL, forcing a sequential evaluation among clauses of a lilter
From: Informatique <ebaechle_at_hospvd.ch>
Date: Thu, 14 May 1998 08:53:45 +0200
Message-ID: <MPG.fc4b36757a89b8b989682_at_news-server.unil.ch>
Date: Thu, 14 May 1998 08:53:45 +0200
Message-ID: <MPG.fc4b36757a89b8b989682_at_news-server.unil.ch>
> properties >= to_char(Min_batch_number) AND
> properties <= to_char(Max_batch_number);
>
> This will work if you can be sure that your 'properties' are allways numeric
> and data type varchar2. Also, this one will use index o properties (if there
> is one).
You're absolutely right. I forgot this possibility.
Thanks very much and best regards
Emmanuel Baechler
Lausanne
Switzerland
Received on Thu May 14 1998 - 08:53:45 CEST