View Single Post

   
  #3 (permalink)  
Old 02-28-2008, 08:38 AM
hph
 
Posts: n/a
Default Re: noob question - integer output format, use of SUM in MySql

In article <124rg075197ln6e@corp.supernews.com>,
gordonb.gylhm@burditt.org (Gordon Burditt) wrote:

[snip]
>
> Your query is:
> SELECT SUM(2006) FROM Donors WHERE Source LIKE '%FF%';
>
> In this context, 2006 is a *NUMBER*. `2006` is a field.
> I advise not naming fields so they look like numbers.


Yes, this fixed the problem. I renamed field 2006 to Yr2006 and
everything worked as I'd have expected. Thanks.
Reply With Quote