Below is the syntax for the CHARINDEX :CHARINDEX(,,) SUBSTRING – The value that user needs to find its position in the given STRING POSTION – The position from where its start looking, by default its value is 1