-- 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