Substring() function in SQL Server

Posted on August 14, 2014 by vivekjohari
Substring():- This function is used to return the specified number (third argument “len”) of characters from a given string(first argument) from the start position as specified as the second argument.

Syntax:-

   Select  SUBSTRING ( expression ,start , length )

For example,

       Select  SUBSTRING ( ‘kingmaker’ ,1 , 4 )

Result

    king

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 Functions, SQL Server and tagged . Bookmark the permalink.

31 Responses to Substring() function in SQL Server

  1. Pingback: hpl platten

  2. Pingback: เว็บแทงบอลที่ดีที่สุด

  3. Pingback: เดิมพันกีฬาออนไลน์

  4. Pingback: มาเด้คอลลาเจน

  5. Pingback: Top Realtor Tallahassee

  6. Pingback: rajaqq

  7. Pingback: get it now

  8. Pingback: fun 88

  9. Pingback: idn poker online uang asli

  10. Pingback: 안전놀이터 모음

  11. Pingback: https://internetnews.net.pl/forum/nowe-technologie-f7/poznam-opinie-o-funkymedia-t62.html

  12. Pingback: Website

  13. Pingback: w88club

  14. Pingback: social impact marketing

  15. Pingback: Drogen

  16. Pingback: Nightmare Market

  17. Pingback: เงินด่วนพร้อมใช้

  18. Pingback: business analysis in it industry

  19. Pingback: industry research firms

  20. Pingback: Standard Process Analyzer Market Forecast Covering Growth Inclinations & Development Strategies until 2027

  21. Pingback: w88idw

  22. Pingback: w88126

  23. Pingback: http://antykorozja-poznan.pl/

  24. Pingback: mega poker99

  25. Pingback: www.sejarawan.info

  26. Pingback: parisqq1

  27. Pingback: santali album video gana

  28. Pingback: โบท็อกซ์

  29. Pingback: cannabis oil

  30. Pingback: fun88 casino

  31. Pingback: Freelance WordPress Developer London

Leave a Reply