SQL SERVER CHARINDEX FORMULA

SQL SERVER CHARINDEX FORMULA

--alright viewers, we will be looking at the CHARINDEX function using SQL SERVER SSMS

--the CHARINDEX function locates the character number position of a specific letter of text within a whole word or sentence

--let us start

--so the function is searching for the letter e within thr text value of test and starting from the location of 1 or

--starting to search from the first letter or value of the text called test

SELECT CHARINDEX('e','test',1);

--the result is 2. so the letter e has been found to be located in the second value of the word test.

--so the displayed answer i 2.

--that is it.