Escapes special characters in texts and returns text with escaped characters. STRING_ESCAPE is a deterministic function, which means it always return the same result any time
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
Translate & Replace functions in SQL Server
This article introduces the new TRANSLATE and REPLACE string functions in SQL Server look identical, shifting letters from one to the other. There is a
SQL Server String Functions-4
A string function accepts a string value as an input and returns a string value regardless of the data type. They’re used to convert an
SQL Server String Functions-3
A string function accepts a string value as an input and returns a string value regardless of the data type. They’re used to convert an
SQL Server String Functions-2
A string function accepts a string value as an input and returns a string value regardless of the data type. They’re used to convert an
SQL Server String Functions-1
A string function accepts a string value as an input and returns a string value regardless of the data type. They’re used to convert an