LEFT, RIGHT, CHARINDEX and SUBSTRING functions in sql server Part 23

Thank you so much Venkat sir great teaching

Its better if you remove such very old videos and keep only new ones atlest 5 years old ...

sir how can I add $ in sum(total_amt) plz tell

Very useful videos, excellent teaching thank-you so much sir keep going and upload more videos 💐💐

Explained very well, thank you. Can you please explain how we can divide a value\text into columns if it consist of multiple underscores? like abc_123h_xyz, 2345x_TZ_5546.

Very Nice video sir. thank you so much for this series.

Excellent teaching. Thank you very much 👌

DECLARE @full_path VARCHAR(500)= 'C:\Users\Michael\Documents\Microsoft SQL Server\MyScript.sql';
we want to pull "MyScript.sql
" this one from this full path but I need dynamically can you please answer this

Sir how do i display a name which is starting from 6th position (right end) and i want to display only 4 characters..

In your last example, Can I use Alias name as EmailDomain After group by?

How can I separate the full_name column into the separate columns
EX- I have a table with concatenated full name and I want to display that into separate columns like first_name, middle_name, last_name
Prashant M sonawane
Amit S patil

hello sir, how to get a digit from right side after 4 digit, like from a number 101456678, want to get 4 but using right, please help

I believe you can go GROUP BY EmailDomain instead teacher.

P.S. I was just offered a job yesterday after watching only 22 of your SQL videos! The extra notes you included in the video were actually included in the interview! (Whew!) THANK YOU SO MUCH!!!!!! Hat's off to you teacher!

Do you have any session on synonyms in sql

Cool!

is he from mycodeschool....?

thank you!

Hello Sir How are you? Hope ou are fine. Please tell me how to use alias "Total" in a query such as (english+maths) as Total,(Total/MaxMarks)*100 as Percentage.

or we can easily use this query to get the last email id and then group them up. What do you think?
Select RIGHT(Email,Len(Email) - CharIndex('@',Email)), Count(*)
From tblEmployee
Group by RIGHT(Email,Len(Email) - CharIndex('@',Email))

Hi Sir, Can you make video regarding Partitions in Sql?

How and why is possible for example Sara to with
select CHARINDEX('@', Email)-2, Email from tblEmployee
be 2
and LEN of her Email is 11 here...so 11-2=9...........................
AND
select (LEN(Email) - CHARINDEX('@', Email)-2) from tblEmployee
be 5
so 11-2=5
I got it and know what happened, but can you explain this situation why SQL Server look like (11 - 4) - 2 = 5 when is obviously and logically 11 - 2 = 9
because CHARINDEX('@', Email)-2 giving output 9
If you have time and understand what I'm asking explain, even if I realized what happened here, explain why is this happening like this...when is particularly like I said 11-2=9

Venk, I was playing little with this and look what I found:
select SUBSTRING(Email, CHARINDEX('@',Email)-5,
(LEN(Email) - CHARINDEX('@', Email)-2)) Name
from tblEmployee
group by SUBSTRING(Email,CHARINDEX('@', Email)-5,
(LEN(Email) - CHARINDEX('@', Email)-2))
Well isn't it interesting...

How can I apply the same syntax on ORACLE SQL Developers? This one is in MS SQL server and I'm using ORACLE SQL SERVER. Oracle doesn't support or recognize CHARINDEX command in Oracle. Anyone please?

Muito boa explicação, parabéns!!!

Great explanation Sir

As usual perfect. Best tutorial

what is the syntax to get before @ for an email for whole table

how to get middle name from full name . Like in full name we have 'XYZ' and we have to extract z middle name

Wow very easy to understand! Thank you so much.

Good explanation.  Thank you for posting this.

Thanks for the instructional videos! I've learned a ton from you Venkat. One question that i have is that , wouldn't the result still be the same if the last expression/argument in substring was left out? for example, substring(email,charindex('@',email)) would have been the same as substring(email,charindex('@',email), len(email)-charindex('@',email)?

As said in video what are the other ways to get final shown output??

Suppose I have one String as "ABC EFG", now I want to pick the value using RIGHT function till first Space which comes. How Can I do that?

I want to extract strings: "Self Install Kit" in the log file: xxxxxx: xxxxxxx: xxxxxxx, xxxxxxx: xxxxxxx, xxxxx: xxxxx, xxxxxx: xxxxx, xxxxx: xxxxxxxxx, Install Responsibility: Customer, Install Kit: Self Install Kit, xxxxxxx: xxxxx;xxxxxx;xxxxx, xxxxx

can you help me with the how to locate all the log file that have "Self Install Kit".?

hope you can help.

thanks.

Thank You Sir
Very helpful Video..Very Nice Sir

While Explaining third argument of SUBSTRING() you have used total length of string - till where we do not require.
But my doubt is while defining the Substring() the second argument itself specifies the start position and so the third argument could be total length of the length.
select SUBSTRING('[email protected]',charindex('@','[email protected]')+1,len('[email protected]'))
could give the expedted reply na? why to use (-)minus and all?

I'm sorry i'm very much new to this IT field so just out of confusion/curiosity i'm posting my doubt.

5 days without watching your videos... Hard and long week. Already here, enjoying your lesson :-) Thank you very much!

Hi Venkat could you please explain Substring function with negative (-1) parameter value like select substring(@string,-1,5) etc.

caaarindex

What to do if strong contain many same characters and if i want to calculate under of 3rd or 4rth character?

Such a useful concept explained very simply...I really appreciate your efforts!!

Thank you my good sir

Declare @Name nvarchar(50)
Set @Name='John Deo'
Declare @FirstLetter nvarchar(1)
Declare @SecondLetter nvarchar(1)
Set @FirstLetter=LEFT(@Name,1)
Set @SecondLetter=SUBSTRING(@Name,CHARINDEX(' ',@Name)+1,1)
SELECT 'Short Name = '+UPPER(@FirstLetter)+'.'+UPPER(@SecondLetter) AS ShortName


How To Do Like @Name='John Deo Something' As J.D.S Output

I Use It.. Thanks Sir