Jan: Or you can just temporarily take the $ out of the display SET CURRENCY ' ' PREF 2 B SELECT ALL FROM view SET CURRENCY '$' PREF 2 B
Karen > Jan, > > SELECT (float(CurrentColumn)) FROM tablename > > > Bill > > On Wed, Jan 14, 2009 at 2:22 PM, jan johansen <[email protected]> > wrote: > >> Group, >> >> I need to create a view where a currency value is >> recast as a real number. Can't have the $ in it. >> >> Suggestions please. >> >> Jan >> >> > > >
