In this video, we will be looking at how to replace parts of strings in SQL Server.
My SQL Server Udemy courses are:
70-461, 70-761 Querying Microsoft SQL Server with T-SQL: rebrand.ly/querying-microsoft...
98-364: Database Fundamentals (Microsoft SQL Server): rebrand.ly/database-fundamentals
70-462 SQL Server Database Administration (DBA): rebrand.ly/sql-server-dba
Microsoft SQL Server Reporting Services (SSRS): rebrand.ly/sql-server-ssrs
SQL Server Integration Services (SSIS): rebrand.ly/sql-server-ssis
SQL Server Analysis Services (SSAS): rebrand.ly/sql-server-ssas-mdx
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): rebrand.ly/microsoft-powerpiv...
----
My Excel for PC courses are:
Beginner to Excel - rebrand.ly/microsoft-excel-sp...
Intermediate to Expert Advanced - rebrand.ly/microsoft-excel-ex...
Power Table, Get and Transform and Power Pivot - rebrand.ly/visualizing-data-e...
VBA macros for Excel - rebrand.ly/excel-vba-pc
----
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.
24 авг 2021
