Mega Code Archive

 

Categories / MSSQL / String Functions

 

QUOTENAME

1> -- QUOTENAME: turns a character string in to a valid SQL Server identifier 2> 3> SELECT QUOTENAME("[bad] table name") 4> GO -------------------------------------------------------------------------------- ------------------------------------------------------------------------------ [[bad]] table name] (1 rows affected) 1>