Quotename() function in SQL Server.

This blog will explains ways of formatting string using Quotename() function.

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.