Mega Code Archive

 

Categories / MSSQL Tutorial / String Functions

 

QUOTENAME takes a character string and turns it in to a valid SQL Server identifier, which can be used as a name for a SQ

Server object, such as a table, column, etc. 7> SELECT QUOTENAME("[bad] table name") 8> GO ------------------------------------------------------------------------------------------------------------------------ ------------------ [[bad]] table name] (1 rows affected)