Urgent Help

From: Sarah <sarah_jessicaNOsaSPAM_at_hotmail.com.invalid>
Date: 2000/03/11
Message-ID: <131ab36a.7dbb0f8a@usw-ex0108-062.remarq.com>#1/1

How can I convert number to character in Oracle. Ex.
  select comm from emp;
Output
comm

---

100
150

 Now I want to output as
Comm

---

One Hundred
One Hundred and Fifty

I tried with these
  Select to_char(comm) from emp;
but this is gone in vain.

Thanks
Sarah

• Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful

Received on Sat Mar 11 2000 - 00:00:00 CST