Cannot add this expression to the select list.

Troubleshooting SQL Server

Troubleshooting

Cannot add this expression to the select list.

Message Text

Cannot add this expression to the select list.

Explanation

There are limitations to what expressions are allowed in the select list. The expression you are trying to add may be invalid.

Action

Verify that the syntax in the expression is correct. It is possible that the type of expression is invalid.

See Also

Expressions

Using Operators in Expressions