Loading

Quotename() function in SQL Server.

Pravin More

Comments

Join the conversation! Your thoughts help the community grow.

Many times we come across the situation where we want to store strings in different formats in SQL Server.

Recently I get to know the fuction quotename(), is a SQL Server String function.

It accepts a String as input and returns string of a valid delimited identifier according to pattern given by us.

Below are some examples of this fuction with formatted output.

Query Output

select quotename('Pravin More') --[Pravin More]

select quotename('Pravin [More]') -- [Pravin [More]]]

select quotename('Pravin More', '"') -- "Pravin More"

select quotename('Pravin More''s Name', '''') -- 'Pravin More''s Name'

select quotename('Pravin More', '''') -- 'Pravin More'

select quotename('Pravin More', '|') – NULL

Thanks You.