Substring function example to get particular part of string in SQL Server

Syntax : SUBSTRING(string, startIndex, length)

Example : SELECT SUBSTRING('Vinod Patel',1,10)

Output : 'Vinod Pate'


Syntax : SELECT SUBSTRING(ColumnName,1,4) as 'SubString' FROM TableName

Example : SELECT SUBSTRING(UserName,1,4) as 'SubString' FROM UserInformation

Output : Vino
             Hite
             Hari
             Kiri
             Bhav