Answer to Question #73923 in Databases | SQL | Oracle | MS Access for Todd Boyle

Question

Write a SELECT statement that changes the phrase Today is Monday to Today is Tuesday

Answer 1

You can use REPLACE function to change the phrase.

Syntax:

replace(<string>,<matching_string>,<replace_with>)

MySQL, SQL Server, PostgreSQL:
SELECT replace('Today is Monday', 'Monday', 'Tuesday') AS phrase;

Oracle:
SELECT replace('Today is Monday', 'Monday', 'Tuesday') AS phrase FROM dual;