SQL Replace Function

SQL > SQL String Functions > Replace Function

The Replace function in SQL is used to update the content of a string. The function call is REPLACE( ) for MySQL, Oracle, and SQL Server.

The syntax of the Replace function is:

REPLACE (str1, str2, str3)

In str1, find where str2 occurs, and replace it with str3.

We use the following table for our example.

Table Geography

If we apply the following Replace function:

SELECT REPLACE (Region_Name, 'ast', 'astern') REGION1
FROM Geography;

we get the following result:

REGION1

Eastern

West

Next: SQL TO_DATE Function

This page was last updated on October 12, 2024.

AdBlock Detected!

Our website is made possible by displaying ads to our visitors. Please supporting us by whitelisting our website.