MSDN Library


Returns a Unicode string with the delimiters added to make the input string a valid SQL Server delimited identifier.

Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Database.

Topic link icon Transact-SQL Syntax Conventions

QUOTENAME ( 'character_string' [ , 'quote_character' ] ) 


Is a string of Unicode character data. character_string is sysname and is limited to 128 characters. Inputs greater than 128 characters return NULL.


Is a one-character string to use as the delimiter. Can be a single quotation mark ( ' ), a left or right bracket ( [ ] ), or a double quotation mark ( " ). If quote_character is not specified, brackets are used.


The following example takes the character string abc[]def and uses the [ and ] characters to create a valid SQL Server delimited identifier.


Here is the result set.


(1 row(s) affected)

Notice that the right bracket in the string abc[]def is doubled to indicate an escape character.

Community Additions

© 2015 Microsoft