Recently Added String Functions
Lori Brown covers a few string functions added to SQL Server in the past two versions:
This function is available starting with SQL 2016 and is currently only able to escape JSON characters. To me it’s not super useful just yet but hopefully they will add more types soon.
SELECT STRING_ESCAPE(‘SQLRX’‘s beginning was around “01/20/2008″‘, ‘json’) AS EscapedVal
I haven’t had the need to use
STRING_ESCAPE yet, but one additional function I’d add is