Click here to Skip to main content

Go to Tip/Trick

SQL CASE WHEN condition THEN NumericColumn ELSE 0 END

Niemand25

Rate me:

4.93/5 (9 votes)

7 Jun 2017CPOL

39.1K

5

Be careful with CASE WHEN when dealing with numeric columns and using zero literal

Views

Daily Counts

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Niemand25

Business Analyst Linden

Lithuania

I'm a lawyer in a law firm. Programing is my hobby.

Comments and Discussions

Go to top