Progress
SQL-92
Guide and Reference


REPLACE Function

Replaces all occurrences of string_exp2 in string_exp1 with string_exp3.

SYNTAX

REPLACE ( string_exp1 , string_exp2 , string_exp3 ) 

EXAMPLE

This example illustrates the REPLACE function, replacing the letters ’mi’ in the last_name ’Smith’ with the letters ’moo’:

SELECT REPLACE ( last_name,’mi’,’moo’ )
     FROM customer WHERE last_name = ’Smith’;
 
REPLACE(LAST_NAME,MI,MOO)
-------------------------
Smooth                   
 
1 record selected 

NOTES

COMPATIBILITY

ODBC Compatible


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095