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
31 thoughts on “Substring() function in SQL Server”