Monday, January 26, 2015

LEFT() function in SQL Server

Left():- 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

1 comment:

  1. all your posts are of a great importance! thanks for sharing! research paper editing service will be handy for you in questions of essay or dissertation writing.

    ReplyDelete