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
EXAMPLE
This example substitutes underscores for spaces in customer names.
NOTES
char_expression
,from_set
, andto_set
can be any character expression.- For each character in
char_expression
,TRANSLATE
checks for the same character infrom_set
:- If it is in
from_set
,TRANSLATE
translates it to the corresponding character into_set
(if the character is then
th character infrom_set
, then
th character into_set
).- If the character is not in
from_set
TRANSLATE
does not change it.- If
from_set
is longer thanto_set
,TRANSLATE
does not change trailing characters infrom_set
that do not have a corresponding character into_set
.- If either
from_set
orto_set
is null,TRANSLATE
does nothing.COMPATIBILITY
Progress Extension
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |