RE: Val() doesn't work like I need it to

[Olive, Christopher M Mr USACHPPM]

why are there dollar signs there in the first place?  the dollar sign
display should be a separate entity from the actual number.  what are you
trying to do?

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-----Original Message-----
From: Reuben King [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 08, 2000 1:40 PM
To: [EMAIL PROTECTED]
Subject: Val() doesn't work like I need it to


Val("$12.31") returns 0.  Val("1,120.1") returns 1.. This is starting to 
piss me off.  Am I missing something here?  Am I going to have to write 
a custom tag to simply convert a human-readable number into a number-
number for insertion into an Oracle column? (Oracle's to_number() is 
just as useless, if not more so! urg.)

TIA,
-R
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.