Syntax of Charindex function
- SearchString: Replace SearchString with search text
- OverAllString: Replace OverAllString with given full text.
Read following example carefully for charindex functionOutput of above query is 31
Above query search will start from 8th position of string and we will get output like as shown below
Output of above query is 31