>double checking, thank you, Steve
If you run the above query in VFP (not in SQL Server as I thought), then you don't need to use brackets.
Hmm, what do we do in VFP in this case - use column as is?
select hour, avg(mRating) as AvgRating from Ratings GROUP BY hour
If it's not broken, fix it until it is.
My Blog