LEFT() function in SQL Server

SQL Basic SQL Functions SQL Server

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