Dec 24, 2014

SQL Server: LEFT String Functions in SQL Server

Left: This function use when we want to select a left part of the character string with the specified number of characters.
Syntax:
LEFT ( character_expression , integer_expression )
character_expression: Character expression is the expression of character or binary data, except text or ntext, character_expression can be of any data type.
integer_expression: integer_expression is a positive integer that specifies how many characters of the character_expression will be returned.
For example:
DECLARE @str VARCHAR(60)  
SET @str='dilip Kumar Singh'
select Left(@str,5) AS LeftFiveChar

Result:
LeftFiveChar
------------
dilip

(1 row(s) affected)