[thelist] Case Statements and > < signs (was: Front End...)

[Ken Moore]

Hi Rob,

I used to teach programming. I told my students to fully parenthicize 
everything. This looks like a matter of precedence, ie what is grouped and 
how. I think the 200 and r.AllocatedBy are being compared.

Try this:

CASE WHEN (r.Footage >= 200) AND (r.AllocatedBy Is Null) THEN [r.Footage] 
ELSE 0


Ken

>From: Rob Smith <rob.smith at THERMON.com>
>Reply-To: "thelist at lists.evolt.org" <thelist at lists.evolt.org>
>To: "'thelist at lists.evolt.org'" <thelist at lists.evolt.org>
>Subject: RE: [thelist] Case Statements and > < signs    (was: Front End...)
>Date: Wed, 10 Sep 2003 08:26:00 -0500
>MIME-Version: 1.0
>Received: from acornparenting.org ([216.40.227.23]) by mc8-f14.hotmail.com 
>with Microsoft SMTPSVC(5.0.2195.5600); Wed, 10 Sep 2003 07:01:22 -0700
>Received: (qmail 7688 invoked from network); 10 Sep 2003 13:35:24 -0000
>Received: from localhost (HELO www.acornparenting.org) (127.0.0.1)  by 0 
>with SMTP; 10 Sep 2003 13:35:24 -0000
>Received: (qmail 7649 invoked from network); 10 Sep 2003 13:35:07 -0000
>Received: from smtma.thermon.com (12.5.145.152)  by 0 with SMTP; 10 Sep 
>2003 13:35:07 -0000
>Received: from Unknown [12.5.145.151] by smtma.thermon.com - 
>SurfControlE-mail Filter (4.6); Wednesday, 10 September 2003, 08:25:07
>Received: by smtmb.tmc.local with Internet Mail Service (5.5.2656.59)id 
><SMZSD9YL>; Wed, 10 Sep 2003 08:26:06 -0500
>X-Message-Info: JGTYoYF78jHnJuHNSY8/mOtt1S8+tc8r
>Return-Path: <rob.smith at THERMON.com>
>Delivered-To: thelist at lists.evolt.org
>Message-ID: <0CEC8258A6E4D611BE5400306E1CC9271E4F3A at smtmb.tmc.local>
>X-Mailer: Internet Mail Service (5.5.2656.59)
>X-BeenThere: thelist at lists.evolt.org
>X-Mailman-Version: 2.1b5
>Precedence: list
>List-Id: thelist at lists.evolt.org <thelist.lists.evolt.org>
>List-Help: <mailto:thelist-request at lists.evolt.org?subject=help>
>List-Post: <mailto:thelist at lists.evolt.org>
>List-Subscribe: 
><http://lists.evolt.org/mailman/listinfo/thelist>,<mailto:thelist-request at lists.evolt.org?subject=subscribe>
>List-Archive: <http://lists.evolt.org/pipermail/thelist>
>List-Unsubscribe: 
><http://lists.evolt.org/mailman/listinfo/thelist>,<mailto:thelist-request at lists.evolt.org?subject=unsubscribe>
>Sender: thelist-bounces at lists.evolt.org
>Errors-To: thelist-bounces at lists.evolt.org
>X-OriginalArrivalTime: 10 Sep 2003 14:01:22.0791 (UTC) 
>FILETIME=[045AD770:01C377A4]
>
>Nevermind..
>
>It should be:
>
>CASE WHEN r.Footage >= 200 AND r.AllocatedBy Is Null THEN [r.Footage] ELSE 
>0
>END
>AS lengthsmore225,
>
>sorry.
>
>--
>* * Please support the community that supports you.  * *
>http://evolt.org/help_support_evolt/
>
>For unsubscribe and other options, including the Tip Harvester
>and archives of thelist go to: http://lists.evolt.org
>Workers of the Web, evolt !

_________________________________________________________________
Express yourself with MSN Messenger 6.0 -- download now! 
http://www.msnmessenger-download.com/tracking/reach_general