Re: use of _ in sql on i5

translate() replaces characters one by one independently of their
relative positions
when neither to nor from argument is given, it acts as an upper-case
function :
TRANSLATE(string) = UPPER(string)

replace() replaces occurrences of a string with an other string, which
can be of a different size

ex: translate('123 312', 'abc', '312') = 'bca abc'
replace('123 312', '312', 'abc') = '123 abc'

nicolas

David FOXWELL a écrit :

Great thanks. But I didn't see why translate didn't work.