SQL CHARINDEX

Transact-SQL (TSQL) Quick Tips – SQL CHARINDEX Function Here is a simple example of how the SQL CHARINDEX function works.  You can copy this code into your Query Window and EXECUTE as-is.  The code includes a #temp table with data to illustrate the functionality.  You can modify to suit your needs. The SQL CHARINDEX function searches … Read more

SQL SUBSTRING

Transact-SQL (TSQL) Quick Tips – SQL SUBSTRING Function Here is a simple example of how the SQL SUBSTRING function works.  You can copy this code into your Query Window and EXECUTE as-is.  The code includes a #temp table with data to illustrate the functionality.  You can modify to suit your needs. The SQL SUBSTRING function returns … Read more