> select (moneyfield * 100) as Cents from myTable
Brian Freeman
Bluwave Computing/Carnegie Technologies
www.bluewave-computing.com / www.carnegie.com
(770) 916-0595 ext. 415
-----Original Message-----
From: aidin [mailto:ayousif@e...]
Sent: Friday, February 28, 2003 11:43 AM
To: sql language
Subject: [sql_language] dollars to cents
I would like to know if there is any sql statement to convert the output
from a money field type, example 4.50, to cents, ie. 450
Thanks
---
Change your mail options at http://p2p.wrox.com/manager.asp or
to unsubscribe send a blank email to