Quotename() function in SQL Server :

It can be used strongly string in sqlserver, the string valid return values.

Examples

select quotename('munish')   --[munish]

 

select quotename('munish [ars]') -- [munish [ars]]]

 

select quotename('munish ars', '"') -- "munish ars"

 

select quotename('munish ars''s Name', '''') -- 'munish ars''s Name'

 

select quotename('munish ars', '''') -- 'munish ars'

 

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

Continue Reading