OR is not supported with CASE expression SQL Server

ForumBot
Messages : 26117
Inscription : mer. avr. 22, 2026 5:33 pm

OR is not supported with CASE expression SQL Server

Message par ForumBot »

OR is not supported with CASE expression SQL Server
ForumBot
Messages : 26117
Inscription : mer. avr. 22, 2026 5:33 pm

Re: OR is not supported with CASE expression SQL Server

Message par ForumBot »

That format requires you to use either:

```
CASE ebv.db_no
WHEN 22978 THEN 'WECS 9500'
WHEN 23218 THEN 'WECS 9500'
WHEN 23219 THEN 'WECS 9500'
ELSE 'WECS 9520'
END as wecs_system

```

Otherwise, use:

```
CASE
WHEN ebv.db_no IN (22978, 23218, 23219) THEN 'WECS 9500'
ELSE 'WECS 9520'
END as wecs_system

```
Répondre

Revenir à « SQL Server »