SQL Query | How to Extract Numbers and Alphabets from an alphanumeric string | Translate function

Just Perfect!!!

Awesome thank you so much....

🎉🎉 super stuff

Making it bit simpler:

Declare @v varchar(100);
set @v='576SDJASL78JKFD90';
Select replace(translate(@v,'0123456789',' '),' ',''),
replace(translate(@v,'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmopqrstuvwxyz',
' '),' ','')

Result:

SDJASLJKFD | 5767890



Ziakhan

Excellent! Thanks for sharing!

If this is the case we can simply use left and right operators in sql to seperate please solve the same when alphanumeric string is combined as'xas123ssh333'.

Thank you so much mam, it is very helpful video and please provide us create and insert query ,it will help us for practice

Very help full

Could we have used the Patindex function as well ?

Error -

The second and third arguments of the TRANSLATE built-in function must contain an equal number of characters.

Thank you

Is this query worked in ORACLE 11g

Awesome video!!!!

For the same data can we sperate alphanumeric by -
Eg: AB-34-HP

Thank you so much! This is exactly what I was looking for!

Amazing explanation mam 👏

Tablename-SQL
Column name-NAME
PRA9798VIN
RA556JA
VICK989Y

Your video helped so much. Thank you!

Hi, How do you separate alphabets from this data for example A256-20G, A658-78L, G588-100ML, I just only pull unit only (G, ML, L). any solution?