Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## TRANSLATE

> 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

> - `char_expression`, `from_set`, and `to_set` can be any character expression.

> - For each character in `char_expression`, `TRANSLATE` checks for the same character in `from_set`.

> - If it is in `from_set`, `TRANSLATE` translates it to the corresponding character in `to_set` (if the character is the`n`th character in `from_set`, the `n`th character in `to_set`).

> - If the character is not in `from_set` `TRANSLATE` does not change it.

> - If `from_set` is longer than `to_set`, `TRANSLATE` does not change trailing characters in `from_set` that do not have a corresponding character in `to_set`.

> - If either `from_set` or `to_set` is `NULL`, `TRANSLATE` does nothing.

> ##### Compatibility

> Progress extension

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