invalid character in column name

[junkjones]

I have an MS SQL database with a column called 'Long/Short'. When I try to pull up the column:

select temp_ID, MAX(Long/Short) as longshort from table
group by temp_ID

I get an error (of course) of "Invalid column name 'long'."

So my question is, is there another way to pull up this column without changing the name of the column? It is being used in a bunch of other places and I would rather figure out a workaround than rename the column.

Thanks!

 

[ClaireHCM]

Try this

select temp_ID, MAX([Long/Short]) as longshort from table
group by temp_ID