QUOTENAME takes a character string and turns it in to a valid SQL Server identifier, which can be used as a name for a SQL : QUOTENAME « String Functions « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. String Functions
3. QUOTENAME

Server object, such as a table, column, etc.


7> SELECT QUOTENAME("[bad] table name")
8> GO



------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
------------------
[[bad]] table name]



(1 rows affected)