LEFT() function in SQL Server

Posted on January 26, 2015 by vivekjohari

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

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