Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 0FDF7475EB9 for ; Tue, 24 Sep 2002 10:20:45 -0400 (EDT) Received: from qmail.crp.dnsalias.com (r-bo043-1-167.tin.it [213.45.32.167]) by postgresql.org (Postfix) with SMTP id 82B87476170 for ; Tue, 24 Sep 2002 10:20:38 -0400 (EDT) Received: (qmail 12266 invoked from network); 24 Sep 2002 14:20:39 -0000 Received: from unknown (HELO smtp.crp) (10.1.3.151) by web1.crp with SMTP; 24 Sep 2002 14:20:39 -0000 Received: (qmail 13183 invoked from network); 24 Sep 2002 14:20:39 -0000 Received: from unknown (HELO triton) (10.1.1.32) by sentinel.crp with SMTP; 24 Sep 2002 14:20:39 -0000 From: "Matteo Beccati" To: Subject: Re: select case problem Date: Tue, 24 Sep 2002 16:20:38 +0200 Message-ID: <2780D698C269CB4EB303715BA48B6A1033DE@sole.CRP> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.3416 Importance: Normal In-Reply-To: <1032903934.28249.2.camel@Falcon> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/302 X-Sequence-Number: 9579 Hi, select case when division_no is null then 'no division' else 'with division' end from employee; Is the right syntax Regards -- Matteo Beccati http://www.phpadsnew.com http://phppgads.sourceforge.net