Substring() function in SQL Server

SQL Functions 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

DMCA.com

6 thoughts on “Substring() function in SQL Server

  1. Pingback: hpl platten

Leave a Reply