Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Briceston
Yak Posting Veteran
54 Posts |
 Posted - 2013-10-06 : 13:20:47
|
| Hi,I have the below Ms.Access code that I would to transition into SQL.Is CCUR a usable function in SQL, or would I have to use the convert to money functiom?Charges: Sum(((CCUR([Fee Schedule Rate])*CCUR([Units_Charged])))) |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-10-06 : 17:07:25
|
There is MONEY and SMALLMONEY data type in SQL Server - you could use it like this:CAST([Fee Schedule Rate] AS MONEY) http://technet.microsoft.com/en-us/magazine/dd424925.aspx |
 |
|
|
|
|
|
CCUR format in sql