Replacing text in SQL Server: REPLACE, STUFF and TRANSLATE

In this video, we will be looking at how to replace parts of strings in SQL Server.
My SQL Server Udemy courses are:
----
My Excel for PC courses are:
----
There are a few ways that you can replace text in SQL Server.
REPLACE allows you to find a string in a bigger string, and replace it with something else.
However, if you don't know what you are replacing, but where it is, then you can use STUFF. It allows you to replace LEFT and RIGHT functions with a single STUFF function.
If you want to replace multiple strings, or maybe switch strings around, then you might want to have a look at the TRANSLATE function.

[surajfartyal]

Thanks for the making this video man. It really helped.

[shadowitself]

brilliant content
super comprehensive approach
thx!