Tag: SQL CHARINDEX

Use of CHARINDEX Function in SQL

Use of CHARINDEX Function in SQL: (1) “CHARINDEX” function is used to get the position of Character from a string. (2) Let’s take an example to get the position of ‘e’ from the Vendor Address field in the Vendor table as shown. Note: (i) This function performs a case-insensitive search and (ii) Gives first find position …