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
Share this:
Discover more from Technology with Vivek Johari
Subscribe to get the latest posts sent to your email.
31 comments