This function returns the specified number of characters from the left part of the given character string.
Syntax
Select LEFT (‘Vivek’,2)
Vi
Subscribe to get the latest posts sent to your email.
I am currently working as a Senior Database Professional and have around 18 years of experience in database. Degree:- Master Degree in Computer(MCA) Certification course in Data Science & Machine Learning from Indian Institute of Technology (IIT), Delhi Work experience:- Designing of the database. Database Optimization. Writing Complex Stored Procedures,Functions,Triggers etc. Designing and developing SSIS & DTS packages. Designing SQL Reports using SSRS. Database Server Maintenance. Certification:- MCTS: DA-100: Analysing Data with Microsoft Power BI MCTS: DP-300: Administering Relational Databases on Microsoft Azure Microsoft certified Sql DBA in Sql server 2008 (MCTS). Microsoft certified BI professional in Sql server 2008 (MCTS). Oracle certified profession DBA in ORACLE 10g (OCP) certified profession DBA in ORACLE 9i (OCP) My other publication Technical Blog:- Technologies with Vivek Johari Guest Author and Blogger at sqlservercentral.com
Subscribe now to keep reading and get access to the full archive.
… [Trackback]
[…] Info to that Topic: techmixing.com/2015/01/left-function-in-sql-server.html […]
… [Trackback]
[…] Read More on to that Topic: techmixing.com/2015/01/left-function-in-sql-server.html […]
… [Trackback]
[…] Here you can find 61560 additional Information on that Topic: techmixing.com/2015/01/left-function-in-sql-server.html […]
… [Trackback]
[…] Find More Info here to that Topic: techmixing.com/2015/01/left-function-in-sql-server.html […]
… [Trackback]
[…] Find More Info here to that Topic: techmixing.com/2015/01/left-function-in-sql-server.html […]
… [Trackback]
[…] Information to that Topic: techmixing.com/2015/01/left-function-in-sql-server.html […]
… [Trackback]
[…] Read More to that Topic: techmixing.com/2015/01/left-function-in-sql-server.html […]
… [Trackback]
[…] Here you can find 50625 more Info on that Topic: techmixing.com/2015/01/left-function-in-sql-server.html […]
… [Trackback]
[…] Find More here on that Topic: techmixing.com/2015/01/left-function-in-sql-server.html […]
… [Trackback]
[…] Find More on on that Topic: techmixing.com/2015/01/left-function-in-sql-server.html […]
… [Trackback]
[…] Here you can find 66995 more Information to that Topic: techmixing.com/2015/01/left-function-in-sql-server.html […]
… [Trackback]
[…] Info on that Topic: techmixing.com/2015/01/left-function-in-sql-server.html […]
… [Trackback]
[…] Find More here to that Topic: techmixing.com/2015/01/left-function-in-sql-server.html […]
… [Trackback]
[…] Find More here on that Topic: techmixing.com/2015/01/left-function-in-sql-server.html […]
… [Trackback]
[…] Find More on that Topic: techmixing.com/2015/01/left-function-in-sql-server.html […]
… [Trackback]
[…] There you will find 48796 additional Info on that Topic: techmixing.com/2015/01/left-function-in-sql-server.html […]
… [Trackback]
[…] There you can find 60575 additional Info to that Topic: techmixing.com/2015/01/left-function-in-sql-server.html […]
… [Trackback]
[…] Information to that Topic: techmixing.com/2015/01/left-function-in-sql-server.html […]
… [Trackback]
[…] Read More on on that Topic: techmixing.com/2015/01/left-function-in-sql-server.html […]
… [Trackback]
[…] Find More Information here to that Topic: techmixing.com/2015/01/left-function-in-sql-server.html […]
… [Trackback]
[…] Information to that Topic: techmixing.com/2015/01/left-function-in-sql-server.html […]
… [Trackback]
[…] Find More to that Topic: techmixing.com/2015/01/left-function-in-sql-server.html […]
… [Trackback]
[…] Read More here to that Topic: techmixing.com/2015/01/left-function-in-sql-server.html […]
… [Trackback]
[…] Find More Information here to that Topic: techmixing.com/2015/01/left-function-in-sql-server.html […]
… [Trackback]
[…] Read More on that Topic: techmixing.com/2015/01/left-function-in-sql-server.html […]
… [Trackback]
[…] Find More Information here to that Topic: techmixing.com/2015/01/left-function-in-sql-server.html […]
… [Trackback]
[…] Read More on on that Topic: techmixing.com/2015/01/left-function-in-sql-server.html […]
… [Trackback]
[…] Find More Information here on that Topic: techmixing.com/2015/01/left-function-in-sql-server.html […]
… [Trackback]
[…] Read More on that Topic: techmixing.com/2015/01/left-function-in-sql-server.html […]
… [Trackback]
[…] Read More on that Topic: techmixing.com/2015/01/left-function-in-sql-server.html […]
… [Trackback]
[…] Here you can find 80235 additional Information on that Topic: techmixing.com/2015/01/left-function-in-sql-server.html […]