QUOTENAME_UDF (VARCHAR)

Definition

This user-defined function (UDF) creates a valid SQL Server delimited identifier by returning a Unicode string with the delimiters added.

QUOTENAME_UDF(STR VARCHAR) 

Parameters

STR VARCHAR

The string to be transformed.

Returns

Returns a varchar with the delimited identifier added.

Usage example

Input:

SELECT QUOTENAME_UDF('test');

Output:

"test"

Last updated