Tag:Function usage

  • Explain the Use of Substring Function in SqlServer Database


    Function: Returns part of a character, binary, text, or image expression Syntax:SUBSTRING ( expression, start, length ) 1. substring (string of operation, position of beginning interception, number of characters returned) For example: Return’c C C’from’abbccc’, CHARINDEX function usage (charindex (search string, search string, start location), such as finding the location of the first’c’ in’abbccc’, CHARINDEX […]