In this article, we will explore SUBSTRING, PATINDEX and CHARINDEX string functions for SQL queries. Introduction While working with the string data, we perform various calculations, analytics, search, replace strings using SQL queries. SQL Server provides many useful functions such as ASCII, CHAR, CHARINDEX, CONCAT, CONCAT_WS, REPLACE, STRING_AGG, UNICODE, UPPER for this purpose. In this … Continue reading SUBSTRING, PATINDEX and CHARINDEX string functions in SQL queries