Sql function to get number from string

[@zoomtomanav]

This is Awesome!. Thank you sir. From years I have been watching your tutorials and you are always the Best. Again, Thank you for this and all the amazing tutorials.

[@vikasverma93]

Dear sir, your content is world class..

[@Genial_Gouthi]

i agree

[@KuldeepSingh-nq1vi]

Wow Great Explanation Sir, I understood the function correctly...

[@AmAddis]

Thank you Mr Venkat Big respect Sir. I have done this before watching this . Here is the piece of code . DECLARE @string VARCHAR(32) DECLARE @length INT =1 DECLARE @numbersOnly WHILE PATINDEX (‘%[^0-9]%’ , @string) > 0 BEGIN SET @string = STUFF(@string, PATINDEX (‘%[^0-9]%’ , @string),@string, @length,’ ‘) END SET @numbersOnly = @string SELECT @numbersOnly

[@elhammasoudinejad1751]

DECLARE @string VARCHAR(32) ='Di2a3n4a5' DECLARE @length INT =1 DECLARE @numbersOnly VARCHAR(32) ='' WHILE PATINDEX ('%[0-9]%' , @string) > 0 BEGIN SET @numbersOnly = @numbersOnly+ substring(@string ,PATINDEX ('%[0-9]%' , @string),1) SET @string = STUFF(@string, PATINDEX ('%[0-9]%' , @string),@length,'') END select @string , @numbersOnly

[@jacksparrowcapitan3232]

Great work form interview perspective, waiting for more

[@DEEPAKYADAV-rp6rh]

Hello Sir, Please start continuing the Azure tutorial Videos series after #34, ......Eagerly Waiting. You are an awesome teacher.

[@AnilKumar-bd2yt]

Nice sir. Your big fan. Upload more sql.

[@devarakondasankararao3802]

Venkat sir is the great teacher

[@sowjanyakamatam4017]

this is perfect!, Thank you for saving the day

[@aniketkolte17]

Hello sir, please continue azure tutorial series and include Azure-DevOps also in the series.

[@chakravaramranganath9036]

Thank you for the information, appreciate that

[@NIRMALA-ts6pf]

Thank you so much sir 🙏, it will help us lot.

[@ravibathula9105]

sir please do videos on performance tuning /index optimisation/query cost and etc..

[@sahej97]

Awesome Tutorial

[@mekuriaamu]

you are special. I wish you could do SSAS

[@vishalkumargupta5484]

Awesome sir

[@dharmeshwarpandey7637]

I liked it first sir...love ya...

[@PrasannanGachinmani]

We can use ASCII function to extract numbers and alphabets

[@raghun2232]

create function fn_getnumber (@string varchar(100)) returns varchar(100) as begin while patindex('%[^0-9]%')>0 begin set @string=replace(@string,substring(@string,patindex('%[^0-9]%'),1),1,' ') end return @string end by using relace also we can do know sir

[@santhoshn3766]

Awesome!!! thanks ..

[@georget10i]

Thank You!

[@MajidKhan-ln6fs]

Thank you

[@nikhithareddy2289]

Sir, pls make a video on Initcap a string like "iam learning sql server" using sql

[@bhargavidutt857]

Hi Venkat, Thank you for ur detailed explanation. todayI have asked to display the highest occurrence of the character in a string .i tried as "SELECT case when ( REGEXP_INSTR('jhon doe', '[a]+', 1,2)) >0 then 'a' else 'notfound' end "higest_ocuured_charecter" FROM DUAL; can you please help with more generic query for this question Input:- 'jhon doe' output:- 'O'

[@SonicVisualGR]

Hi, thank you for the great video. One question, - what if @input variable contain non English characters ? What if we don't know what language character comes in the @input variable ? For example lets say @input contain a mix of Greek, English and Numeric characters (for example 'H2ell3oW5or6ldΓει6αΣ7ουΚ8όσ9με' ) ?

[@Luth1us]

What about TRANSLATE() function? It can solve this problem easily.

[@itumandal22]

Too good

[@vinays1234]

What is microservice?

[@shubhampatil-sf4km]

Select TRIM (' Hello World'); How to remove Extra spaces Between "Hello World" And which Function we need to use in MS-SQL?

[@Shri-RAM-JaiBajrangBali]

HI SHUBHAM PLEASE USE THE COMMAND DECLARE @STRING VARCHAR(100)=' Hello World' SELECT REPLACE(REPLACE(REPLACE(@STRING ,CHAR(32),'()'),')(',''),'()',CHAR(32)) AS STRIN_WITHOU_SPACES