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?

Accepted Answer

Wrap the column name in brackets like so, `from` becomes [from].

```
select [from] from table;
```

It is also possible to use the following (useful when querying multiple tables):

```
select table.[from] from table;
```

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

Solution

Problem

Related problems