In this article, I describe How to use NULLIF in SQL server. As we know nullif clause used to checks the value is null or not. If the value is null then we define some default value.
SELECT ISNULL(NULLIF(Amount,''),0.00)FROM DBO.EMPLOYEE
In this above case, I am using isnull and nullif clause, first nullif clause check the amount is null or not .If it is null then return empty after that isnull clause will check whether the result is empty then return our default value.
Post your comments / questions
Recent Article
- OSError: cannot open resource - Python
- Python read file line count
- How to Encode & Decode using Base64 in Python?
- Unspecified error-The function is not implemented. Rebuild the library with Windows, GTK+ 2.x or Cocoa support.
- How to generate a Captcha verification code image with Python?
- How to show an image using path python PIL?
- How to remove Background from the images using Python?
- Python generate QR code image
Related Article