Substring() function in SQL Server

Substring():- This function is used to return the specified number (third argument “len”) of characters from a given string(first argument) from the start position as specified as the second argument.

Syntax:-

   Select  SUBSTRING ( expression ,start , length )

For example,

       Select  SUBSTRING ( ‘kingmaker’ ,1 , 4 )

Result

    king