Re: numeric to fully-written-numbers pl/sql translator

Try this, i'm not sure about other languages though. This kind of procedure is dotted around various web sites so you may find another language somewhere.

• Cut Here ===============

  Function Spell (v_number in number) return varchar2 is

  v_word varchar2(1000);

  begin

  select to_char(to_date(v_number,'j'), 'Jsp')   into v_word
  from dual;

  return v_word;

  end;

• END ===============

Guy Hendrickx wrote in message <7k36da$glv$1_at_naxos.belnet.be>...
>Hi,
>I'm looking for a pl/sql procedure which is capable of translating
>a numeric value to a full-text string :
>ex. '20' will become 'twenty'.
>If possible it should be available for Ducth, French and English.
>If only one of the above languages is supported, I'm still interested.
>Kind regards,
>Guy Hendrickx
>Guy_at_Cereus.BE
>
>
Received on Mon Jun 14 1999 - 10:41:50 CDT