Convert a small query from access to Sql Server

I have a small piece of code that is giving me grief, trying to convert it into sql server. The code is from access.

CCur(Nz([TotalDeposits])+Nz([TotalCC])) AS TotalCollections 

Open in new window

thanks in advance,
Who is Participating?
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
CAST(COALESCE(TotalDeposits,0) + COALESCE(TotalCC,0) as money) as TotalCollections
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.