1>2> 3>4> -- CHARINDEX(): find the first occurrence of a substring within another string.5>6>7> SELECT CHARINDEX('sh', 'Washington')8> GO----------- 3(1 rows affected)1>2>