This is from the sql reference guide:
Monocase the string *abcdef*.
SELECT TRANSLATE(*abcdef*) FROM SYSIBM.SYSDUMMY1
Returns the value *ABCDEF*.
Monocase the mixed character string.
SELECT TRANSLATE(*abdef * ) FROM SYSIBM.SYSDUMMY1
Returns the value *ABDEF*
Given that the host variable SITE is a varying-length character string
with a value of *Pivabiska Lake Place*.
SELECT TRANSLATE(:SITE, *$*, *L*) FROM SYSIBM.SYSDUMMY1
Returns the value *Pivabiska $ake Place*.
SELECT TRANSLATE(:SITE, *$$*, *Ll*) FROM SYSIBM.SYSDUMMY1
Returns the value *Pivabiska $ake P$ace*.
SELECT TRANSLATE(:SITE, *pLA*, *Place*, *.*) FROM SYSIBM.SYSDUMMY1
Returns the value *pivAbiskA LAk. pLA..*.
On 9/16/2008 at 3:32 PM, in message
<OFCE5F99C7.B7A2598B-ON852574C6.006B110D-852574C6.006B4EB0@xxxxxxxx>,
Alan Shore <AlanShore@xxxxxxxx> wrote:
HHHEEELLLPPPP!!!
There is a command in SQL you can use to translate the contents of a
field
to something else
I have XLATE in my mind, but I cannot find anything on it, but now I
have
XLATE in my mind, its like the song "Its a small world after all"
Hells bells - now I have that @#$%^& tune running through my mind as
well
Anyone help me with the sql command for translate?
Thanks in advance
Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxxxxx
P:(631) 244-2000 ext. 5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill
midrange.com
