SQL Tutorials - 8.System Functions_1 - LEN / LEFT / RIGHT / SUBSTRING / CHARINDEX

preview_player
Показать описание
In this tutorial we will learn how to use the system function in SQL, and we will talk about :

1. LEN Function: Return the length of the value

2. LEFT Function : Return the left part of the character with specified number

3. Right Function : Return the right part of the character with specified number

4. Substring Function : Return the substring starting at the position specified by number

5. Charindex Function : Used to search for an expression with another expression and return
its started position if found

Last but not the least, SUBSCRIBE to my YouTube channel to stay updated about the regularly uploaded new videos.

  1. Melvin King
  2. SQL Tutorials
  3. System Fubctions in SQL
  4. Len in SQL
  5. Left function in SQL
  6. Substring function in SQL
Рекомендации по теме
SQL Tutorials - 0:08:13

SQL Tutorials - 8.System Functions_1 - LEN / LEFT / RIGHT / SUBSTRING / CHARINDEX

SQL Tutorial for 0:44:57

SQL Tutorial for Beginners

SQL Function | 0:03:16

SQL Function | single row and multi row functions in sql

SQL Course for 3:10:19

SQL Course for Beginners [Full Course]

SQL Tricks | 0:00:18

SQL Tricks | You Must Try This ! Windows Functions

Learn Basic SQL 0:17:40

Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3

Fastest Way To 0:00:11

Fastest Way To Learn SQL

SQL Window Function 0:24:55

SQL Window Function | How to write SQL Query using RANK, DENSE RANK, LEAD/LAG | SQL Queries Tutorial

What is Java 0:28:20

What is Java Based Configuration? | 15 days to Spring Boot Mastery

SQL Window Functions 0:10:13

SQL Window Functions in 10 Minutes

SQL Views In 0:04:23

SQL Views In 4 Minutes: Super Useful! Wow! Crazy! Amazing! I'm Crying Tears Of SQL Joy.

What is SQL 0:03:19

What is SQL | SQL Explained | SQL in 3 Minutes | Intellipaat

SQL - Complete 3:16:14

SQL - Complete Course in 3 Hours | SQL One Shot using MySQL

SQL: Combine (Concatenation) 0:00:13

SQL: Combine (Concatenation) multiple columns into one field using CONCAT () function.

Learn SQL Basics 0:16:57

Learn SQL Basics in Just 15 Minutes!

Learning PL/SQL programming 0:29:21

Learning PL/SQL programming

SQL | Windows 0:00:37

SQL | Windows Vs Aggregate Functions

Introduction to SQL 0:06:31

Introduction to SQL | DDL, DML, DQL, DCL, TCL Commands in SQL

5 Best SQL 0:00:33

5 Best SQL Websites to Practice n Learn Interview Questions for FREE

Built in functions 0:50:43

Built in functions in SQL Server Part 1

Stored Procedures vs 0:01:00

Stored Procedures vs functions - practical demo #shorts #sql #sqlqueries #coding #sqlinterview

SQL Basics for 0:27:51

SQL Basics for Beginners | Learn SQL | SQL Tutorial for Beginners | Edureka

Roadmap for Learning 0:04:52

Roadmap for Learning SQL

SQL Server Interview 0:00:55

SQL Server Interview Questions and Answers :- What to prepare ?

Комментарии
Автор

Thank you. Your video is very helpful as i am trying to learn SQL. I have a question. what if i have a column (Location) with (Los Angeles, CA) i want to make 2 columns(City) +(State) out this one column. how can you transfer values from Location to these new columns using substring?

alia
Автор

unrelated to the video but relevant to the video where you separate first and last names, what do you do if there are no marks or characters between your first and last names, especially when the first and last names in your columns have different lengths if you specify the number of letters to be returned in the right or left columns, it may undesired consequences, for example if you return three characters but the lenght of the first name is maybe five characters and the next one is six, and so on, how do you only return the first name or last name...

Vanguardclass