Implicit Conversion Problem with Money

[nutrotek]

Trying to run the following query using field Cost(Money):

CASE WHEN Cost IS NULL THEN 'N/A' ELSE CONVERT (MONEY, Cost , 1) END

I get an implicit conversion. How do I fix?

 

[SQLDenis]

1) in order to display n/a you have to make it varchar, you can't mix datatypes. what is the datatype of Cost ? you should be able to do this with a simple COALESCE and convert instead of CASE

2) do not use money because it causes rounding errors


Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com
Google Interview Questions