18 how to remove special characters from SQL

preview_player
Показать описание
how to remove special characters from sql
Download the file\script used in the Video from below link

how to remove special characters from sql
how to remove special characters from sql query
How do I remove special characters from a string in SQL Server?
How do I remove all special characters?
How do I remove all characters from a string in SQL?

Happy Learning.

Рекомендации по теме
Комментарии
Автор

Very Helpful, Thank you for amazing content !!

deepakj
Автор

I have been looking for such videos since I have been working on a small project, .. Thanks much appreciated.. besides I sent you an email for help

ericsos
Автор

helpful ! one question what have you used ||*9*9|| in the replace function?

rajankitjaiswal
Автор

Akil sir yours tutorials are Rock 👍, I would like to suggest you to make blog also and definitely you'll get good earnings via ads

radhapatel
Автор

I am coming after 2 years of this video. I downloaded and ran it in the system database, then ran the function on my query and it is taking ages to show results. Please where am I getting it wrong?

zslrjfr
Автор

Sir ! Very good example . It will be great if you can explain the function as well . PLease

LifeFindsItsWay
Автор

Great video sir. Its removing all characters except forward slash (/). What is the reason behind it?

faizanmajid
Автор

What is ufdgetcharacters. It will not show in sql server

shaikhmubashir
Автор

Thank you sir, , It's Also helpful.. Sir i can't find the process to calculate a value & entered in a new column in SSIS

supratimbarman
Автор

Thanks that was what I was looking for !! How can I find it in the Master DB?

CaribouDataScience
Автор

Hi sir, I could not found the script in drive can u check once

avinashc
Автор

The data in first name column is like
Zhang, Tun(I)
Tim, Barton(I)
Gray, casey(I)

So my output should be
Zhang, Tun
Tim, Barton
Gray, casey

How to remove (I)

pvksmaheeth
Автор


O/p is Email.abc
O/p is emai.abc2


For this o/p I want to remove the special characters like, ., @, numbers etc..,

What I need to do plz do needful..

Kindly share query for this

shining_of_Jesus