In Built Funtion in T-SQL - Left and Right

Left - Returns the left part of a character string with the specified number of characters.
LEFT( character_expression , integer_expression )

Right - Returns the Right part of a character string with the specified number of characters.
RIGHT( character_expression , integer_expression )



For Eg.

Select  CompanyName,

Left(CompanyName,5) As [Left],

Right(CompanyName,5) As [Right]

From Customers


Result