An issue with specifying a column "Percent" in SQL Select query

Question

There is a table with a column name PERCENT. I need to run an ordinary SELECT query:

SELECT * 
FROM <my_table>
WHERE PERCENT = 100

However, I get this error message:

Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'PERCENT'

Is there a way to indicate a column so the system accepts it as a column name instead of a function?

Answer 1

PERCENT is a reserved word. Use escape characters:

SELECT *
FROM <my_table>
WHERE [PERCENT] = 100

It is used, for instance, with TOP as in TOP 100 PERCENT.