Quotename (TRANSACT-SQL)

This function returns a unicode string with a separator added. This function changes the input string to a valid separator separated by Microsoft SQL Server.

 

Format:

Quotename ('character _ string' [, 'quote _ character '])

 

Parameters:

' Character_string '

This is a string consisting of Unicode characters.Character_stringIsSysnameThe maximum value is 128 characters. If you enter more than 128 characters, null is returned.

' Quote_character '

This is a single character string, which is assigned as a separator. It can be a single quotation mark ('), Left or right brackets ([ ]), Or double quotation marks ("). IfQuote_characterIf not specified, square brackets are used by default.

Example:

SelectQuotename('%'+'Awpatp'+'%','''')
 

 

Result:
'% Awpatp %'

Source:

Quotename (TRANSACT-SQL)

Http://msdn.microsoft.com/en-us/library/ms176114.aspx