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

Browse More Articles

Tweet

Written by Test

We are Creative Blogger Theme Wavers which provides user friendly, effective and easy to use themes. Each support has free and providing HD support screen casting.