Parentheses in field name 1

[btgroup]

Hello,

Can someone please tell me how to sum a field name when it contains parentheses? My field name is
"GT_Sum_(_new_line_COST_)"

That's without the quotes and when I do SELECT max(GT_Sum_(_new_line_COST_)) I receive an error.

Thanks in advance.

 

[SQLSister]

[GT_Sum_(_new_line_COST_)]

But in the future it is best to avoid field names with () or spaces or using keywords.

Questions about posting. See faq183-874

 

[btgroup]

Thanks Sis. Worked perfectly and saved some aggravation.