Chapters

About SQL Tutorial

SQL Basic Overview

Query Language

Microsoft SQL Server

MySQL

Oracle Database

SQL Database User

SQL*Plus

Connect with System User

Create a new Database User

Log into new User

SQL Database

Create Database in SQL Server

Rename Database

Create Database

Delete or Drop Database

Use Database

SQL Table

Create Table in SQL Server

Order of execution of a Query

Create table

Delete or Drop table

Insert Data into table

SQL Constraints

Constraints Introduction

Cascading referential integrity constraint

Identity Column in SQL Server

SQL Keywords

Keywords Introduction

SQL Data Types

Data Types Introduction

SQL Operators

Operators Introduction

SQL Wildcard Characters

Wildcard Introduction

SQL Joins

SQL Aggregate Function

SQL Views

SQL Dates

Dates Introduction

SQL Stored Procedures

Stored Procedures Introduction

Advantages of Stored Procedures

Simple Store Procedure

Stored procedure with input parameters

Stored Procedure with OUTPUT Parameters

Alter Procedure

SQL Functions

Functions Introduction

Table Valued Functions

Scalar Valued Functions

Stored Procedure VS Function

Multi-Statement Table Valued Functions

Function WITH ENCRYPTION

Function WITH SCHEMABINDING

String Functions in SQL Server

Function Real time Example

SQL Server Date Functions

Other Functions in SQL Server

Cast()

Convert()

Mathematical Functions in SQL Server

Mathematical Functions in SQL

Temporary tables

Local Temporary tables

Global Temporary tables

Indexes

Clustered Index

Non Clustered Index

Unique Index

Advantages and disadvantages of indexes

SQL Server Trigger

Triggers in SQL Server

After update trigger

Instead of insert trigger

Instead of update triggers

Instead of delete trigger

Common table expression (CTE)

Backup and Restore

Backup in SQL Server

Database Restore

How to Use the LEFT() Function in SQL Server: A Complete Guide

Rumman Ansari Software Engineer 2024-07-21 09:35:32 5821 Share
Subject Syllabus Details Subject Details

☰ TContent

☰Fullscreen

Table of Content:

Syntax:


LEFT(Character_Expression, Integer_Expression)

Returns the specified number of characters from the left hand side of the given character expression.

Code:


 Select LEFT('ABCDE', 3)

Output:

The above code will produce the following result-

ABC

How to Use the LEFT() Function in SQL Server: A Complete Guide

Syntax:

Code:

Output:

Stay Ahead of the Curve! Check out these trending topics and sharpen your skills.