Simple and clean method to escape special characters using STRING_ESCAPE system function. STRING_ESCAPE function was introduced in SQL 2016. Here we will see how to use it to escape dome of the special characters.