Posted by hph on 04/26/06 05:08

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.

[Back to original message]