How to deal with SQL column names that look like SQL keywords?

Question

One of my columns is called from. I can't change the name because I didn't make it. Am I allowed to do something like SELECT from FROM TableName or is there a special syntax to avoid the SQL Server being confused?

Answer 1

You can try wrapping the column name in brackets so that from becomes [from] like this:

select [from] from table;

When you are querying multiple tables, then you can use the following query:

select table.[from] from table;