---
title: "At least one of the result expressions in a CASE specification must be an expression other than the NULL constant."
canonical: "https://servicedesk.maxgeo.com/space/MDS/1108508686/At%20least%20one%20of%20the%20result%20expressions%20in%20a%20CASE%20specification%20must%20be%20an%20expression%20other%20than%20the%20NULL%20constant."
format: markdown
---
**Issue: **Error when running scripts in SQL Server

```sql
At least one of the result expressions in a CASE specification must be an expression other than the NULL constant.
```

![image](media://0b272f64-c539-4e5d-b26f-11df0ac2189a)

**Cause: **Known Bug in SQL Server 2019 version 15.0.2000.5

**Resolution: ** Upgrade to the latest Cumulative Update (CU) build.

[https://support.microsoft.com/en-us/topic/kb4518398-sql-server-2019-build-versions-782ed548-1cd8-b5c3-a566-8b4f9e20293a](https://support.microsoft.com/en-us/topic/kb4518398-sql-server-2019-build-versions-782ed548-1cd8-b5c3-a566-8b4f9e20293a) 


> ⚠️ DB Modification
> ⚠️ 
> ⚠️ Before any change is made to a user database (or system), maxgeo recommends competent staff should follow all standard database change management practices and never make untested changes to a production database.  
> ⚠️ Change, test and document all modifications on a test copy of your database to ensure results are as expected before implementing them on your live database. Always ensure a full backup is available in case rollback is required and follow all company change management procedures and practices.