Reformatting number

[Ben Lowndes]

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.