SQL REPLACE

Transact-SQL (TSQL) Quick Tips – SQL REPLACE Function

The following post contains a simple example of the SQL REPLACE function.  I encourage you to copy the code provided below, then paste the code into your Query Window and EXECUTE as-is.  If you execute the code yourself, you will better understand how the SQL REPLACE function works.  The code includes a temp table with data to illustrate the functionality.  Modify the code to suit your needs.

The SQL REPLACE function is used to replace all occurrences of a specified string value with another string value.

Here is the SQL REPLACE function Syntax.  REPLACE ( string_expression , string_pattern , string_replacement )

After running the query above, you should see the following query results:

SQL REPLACE

 

Additional Content

To view additional posts, please visit my site  Home Page

Here, you will find topics covering  Qlikview  SQL Server  Excel VBA

 

Leave a Comment