sql find substring code example

Example 1: locate sql server

SELECT CHARINDEX('b','ab') //returns 2

Example 2: grab part of a string sql

SELECT SUBSTRING('SQLTutorial.org');