3. CHARINDEX - Index of the start of a substring in a string (Search start index can also be given to start searching from a specific position) 4. ‘+’ - Concat using + adds 2 strings together (Most ...