You betcha! That was automated too and is available as an add on
package dubbed "RTFM".



Andrew Giulinn wrote:

I knew we'd get that into this conversation eventually <g>

"Daniel Coppersmith" <daniel_AT_infrontsoftware_DOT_com (AT) N0SPAM (DOT) com> wrote in
message news:4434808f$1 (AT) forums-1-dub (DOT) ..

Would this help?

create function dbo.translate
(str long varchar, orig long varchar, repl long varchar )
returns long varchar
begin
declare i int;
declare lorig int;
declare lrepl int;
declare rslt long varchar;

if str is null or orig is null or repl is null then
return null
end if;
set lorig = length( orig );
set lrepl = length( repl );
if lorig <> lrepl then
return null
end if;
set i = 1;
set rslt = str;
lp: loop
if i > lorig then leave lp end if;
set rslt = replace( rslt, substr(orig,i,1), substr(repl,i,1) );
set i = i + 1;
end loop;
return rslt
end
--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

************************************************** ***************************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer
Edition =and try out the market-leading database for mobile, embedded
and small to medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

************************************************** ***************************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

************************************************** ***************************

The function probably needs to handle all charcter translations
simultaneously, instead of sequentially. If I call TRANSLATE('abba', 'ab',
'ba') I would probably want to get back 'baab', but your function would give
me 'aaaa'.

I think the way to solve this is for your outer loop to go through "str" one
character at a time, and have an inner loop scan "orig" for a match on each
"str" character.

Richard

"Chris Keating(iAnywhere Solutions)"
<NoSpamPlease_k_e_a_t_i_n_g (AT) i_A_n_y_w_h_e_r_e (DOT) com> wrote

*
*
*