> 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