Progress
SQL-92
Guide and Reference


TRANSLATE Function

Translates each character in char_expression that is in from_set to the corresponding character in to_set. The translated character string is returned as the result.

SYNTAX

TRANSLATE ( char_expression , from_set , to_set ) 

EXAMPLE

This example substitutes underscores for spaces in customer names.

SELECT TRANSLATE (customer_name, ’ ’, ’_’)
   "TRANSLATE Example" from customers;
 
TRANSLATE EXAMPLE                  
-----------------                   
Sports_Cars_Inc.__________________________________  
Mighty_Bulldozer_Inc._____________________________  
Ship_Shapers_Inc._________________________________  
Tower_Construction_Inc.___________________________  
Chemical_Construction_Inc.________________________  
Aerospace_Enterprises_Inc.________________________  
Medical_Enterprises_Inc.__________________________  
Rail_Builders_Inc.________________________________  
Luxury_Cars_Inc.__________________________________  
Office_Furniture_Inc._____________________________  
 
10 records selected 

NOTES

COMPATIBILITY

Progress Extension


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