Convert Numbers to Words with SQL

From: GHouck <hksys_at_teleport.com>
Date: 1998/05/25
Message-ID: <3568C0FF.7245@teleport.com>#1/1

A while ago there was a snippet in one of these Oracle newsgroups illustrating a way to display numbers as full (English) words, using SQL and the Date/Char functions.

It created a function that took a number as input, listing the words as output; that is:

select f(123.4) from ...

yielded:

'one hundred twenty three point four'

Does anyone have this example? Or one like it? Or knows where it could be located (without having to start from scratch, that is)?

Thanks,

Geoff Houck
systems hk
hksys_at_teleport.com
http://www.teleport.com/~hksys Received on Mon May 25 1998 - 00:00:00 CDT