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
- How to fix HAXM is not installed |in Android Studio
- How to fix CMOS Checksum Error in Computer or Laptop | SOLVED
- Reactivating windows after a Hardware change on PC or Laptop
- FIXED: Windows reported that the hardware of your device has changed. Error code :0xc004F211
- "redirect" is not defined pylance("reportUndefinedVariable)
- This action cannot be completed because the file is open in SQL Server(SQLEXPRESS) - FIXED
- Unicode error 'unicodeescape' codec can't decode bytes in position 2-3: truncated UXXXXXXXX escape
- Could not find the 'angular-devkit/build-angular:dev-server' builder's node package | Angular Error
Related Article