List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:September 8 1999 1:02pm
Subject:Re: if() after "select" or after "where"?
View as plain text  
Just a sidenote ...

On Wed, 1999-09-08 13:32:28 +0100, Clinton Gormley wrote:
> You want to move the "as Zu" out of the IF statement, so :
> 
> IF(AuP_M_Id like 0 or AuP_M_Id Like 2,

Instead of using LIKE without any wildcards, just do a plain and more
efficient comparison:  AuP_M_Id=0 OR AuP_M_Id=2
And this can also be written as: AuP_M_Id IN (0,2)

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
if() after "select" or after "where"?Bernhard Thoni8 Sep
RE: if() after "select" or after "where"?Clinton Gormley8 Sep
  • Re: if() after "select" or after "where"?Martin Ramsch8 Sep