-- The CHARINDEX() function searches for a substring in a string,
-- and returns the position.
-- If the substring is not found, this function returns 0.
CHARINDEX(substring, string, start)
-- "start" is optional
CHARINDEX(substring, string, start)