Skip to content
Advertisement

How to handle True, False or NULL in where clause

How can I reduce this to only one where statement @state as bit

I wish I could compare True, False or NULL in one select statement

Advertisement

Answer

Would this not work?

Another approach would be to use coalesce on both conditions.

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement