QUOTENAME

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

Syntax

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

Arguments

‘_character_string_’

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

‘_quote_character_’

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.

Return types

nvarchar(258)

Examples

SELECT QUOTENAME('abc[]def');

See Also