How Return Location of sub string in String??
- MS Sql Server
- 732
- March-28-2018
- by Rizwan Saqib
Char index () function Return the Location of substring in String,If we have a string value like this [Education management system] and want to return location of substring [Cati] in String then we use char Index To get result like this
Write this Query
SELECT CharIndex ('Cati' , 'Education management system' ) AS MatchPosition
Execute Query and get result like this
| MatchPosition |
| 4 |
Substring [ Cati ] Location in String on Number 4
