Unlike the built-in QUOTENAME
function this function will try to avoid quoting names that obviously do not need it.
Input | QUOTENAME | SoftadminGuide.Sql_QuoteName | Comment |
---|---|---|---|
Country |
[Country] |
Country |
Only contains A-Z. Does not require escaping. |
Order |
[Order] |
[Order] |
ORDER is a keyword. |
Test* |
[Test* ] |
[Test*] |
The string contains special characters. |