Tuesday, July 02, 2013

Charindex :SQL Server String functions

It the function returns the starting index of string or character in main string. It takes three parameters as input and returns the index which could be int or big int.
charindex( main string , string need to be searched , staring point)
The third parameter is optional which say’s if you can predict where the function start searching in main string you can specify the value else it will by default start from start J
If you are getting zero in output means the character string doesn’t exists in main script and value greater than 0 tells the location of string.

No comments:

Post a Comment