LEFT() function in 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.


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

Select LEFT  (‘Vivek’,2)




About vivekjohari

Database Consultant with more than 11.5 years of experience in database designing & programming and DBA related activities.  Had good experience on different databases like SQL Server, MySQL & Oracle, Azure SQL &  Big Data.
This entry was posted in SQL Basic, SQL Functions, SQL Server and tagged . Bookmark the permalink.

31 Responses to LEFT() function in SQL Server

  1. Pingback: where to buy abstract art online

  2. Pingback: Digital Marketing Service Denver CO

  3. Pingback: referral code

  4. Pingback: didi promo code

  5. Pingback: http://ilcashbuyer.info/usa/real-estate-investment/il/hoffman-estates

  6. Pingback: франк казино официальный сайт

  7. Pingback: influenceur

  8. Pingback: Dentist in Salisbury Maryland

  9. Pingback: novushub: songs: a blog post

  10. Pingback: Dream Market Exit Scam

  11. Pingback: تنظيف البيوت في الرياض

  12. Pingback: Fred

  13. Pingback: Bassett Caterers

  14. Pingback: 바카라

  15. Pingback: houses for sale in Golden Eagle Tallahassee FL

  16. Pingback: dang nhap fun88

  17. Pingback: Drogen kaufen

  18. Pingback: https://cbdque.com/

  19. Pingback: ca cuoc tennis truc tuyen

  20. Pingback: https://wlt.ru/brand/komatsu/

  21. Pingback: assistência informática

  22. Pingback: www.nuguru.info

  23. Pingback: web design dallas tx

  24. Pingback: www.ratucapsa1.club

  25. Pingback: lapakqq

  26. Pingback: sahabat qq

  27. Pingback: login sbobet888

  28. Pingback: rajaqq

  29. Pingback: Togel OnLine

  30. Pingback: đánh bài mậu binh online

  31. Pingback: Ignou Synopsis

Leave a Reply