LSParseNumber() is designed to do what you want.
David
> -----Original Message-----
> From: Ben Lowndes [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 19, 2000 3:26 AM
> To: CF-Talk
> Subject: Reformatting number
>
>
> hi,
>
> I've got a number in the form of 16,511.00
> I'd like to convert it to just 16511
> As SQL doesn't seem to like it in the first format, even though
> I'm getting
> the number from SQL in that format.
>
> Thanks
> ben.
>
> ------------------------------------------------------------------
> ------------
> 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.
