LEFT() function in SQL Server

By | January 26, 2015

LEFT() function in SQL Server

Left() Function

 This function returns the specified number of characters from the left part of the given character string.

Syntax

Select LEFT ( character_expression , integer_expression )For example, the below query will return two characters from the beginning

Select LEFT  (‘Vivek’,2)

Result

Vi

DMCA.com

Leave a Reply