Re: Conversion: Number to Character

From: "Sarah Jessica" <sarah_jessica@hotmail.com> > >I am having a serious problem. How can I convert number into character. I >tried with to_char function but i.e. for converting into dates only. I have >two columns > samount money(14,2) > famount money(14,2) >Now I want to add this samount+famount and the result I want in character. >smaount = 10 >famount = 20 >select (samount + famount) Dollars >from table > >This should give me the result as: Thirty There is absolutely no builtin function I ever heard of in any database that would do this. You're going to have to cut some (non-trivial) code. I had to write this once in 4GL for cheque printing and it wasn't fun. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com