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.

Assume we have the following table:

Table Geography

Region_NameStore_Name
EastBoston
EastNew York
WestLos Angeles
WestSan Diego

If we apply the following Replace function:

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

Result:

REGION1
Eastern
Eastern
West
West

Next: SQL TO_DATE Function




Copyright © 2014   1keydata.com   All Rights Reserved.     Privacy Policy