Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle and MS InterDev question - format currency
In article <66iqhu$a7e_at_sjx-ixn6.ix.netcom.com>, rchrdson_at_ix.netcom.com
says...
> Hello,
>
> I have two fields in my Oracle database that are currency fields,
> NUMBER(9,2), to be specific. I need these fields to be currency files (with
> decimals and $'s) in a Microsoft Visual InterDev web front-end. Is there
> anyone in this group that has experienced this problem and may have a
> solution? Any help would be greatly appreciated.
>
> Thanks,
>
> David
>
>
>
You should be able to do something like this:
select '$'||field1 from table1
Otherwise can't you just use VBScript or JScript to format the data in the Visual Interdev app? If it's more complicated than this please let me know.
Mark Huckabee Received on Wed Dec 10 1997 - 00:00:00 CST