Received: from chapur.com (du-148-233-218-154.prodigy.net.mx [148.233.218.154]) by hub.org (8.10.1/8.10.1) with ESMTP id e9CHiHr60321 for ; Thu, 12 Oct 2000 13:44:17 -0400 (EDT) Received: from desa03 ([192.168.103.49]) by 0chapur.com (8.8.7/8.8.7) with SMTP id MAA13925 for ; Thu, 12 Oct 2000 12:39:35 -0500 Message-ID: <00fb01c03474$193888c0$3167a8c0@chapur> From: "Franz J Fortuny" To: "sqllist" Subject: Standard syntax? Date: Thu, 12 Oct 2000 12:44:40 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200010/118 X-Sequence-Number: 1780 I have been using (with success) this SQL statement in PostgreSQL: select col1, case when col2 = true then col3 else col4 end as colw, colM where .... etc. The above syntax, however, does not work for Interbase (6.01). For those who have had experience in other SQL servers, is this a "standard" or ANSI 9X compatible syntax or should I refrain from such syntax if I want my statements to be transportable from SQL Server to SQL Server? Best regards, Franz Fortuny