I need to select a nullable bit column in a view, but use a default value of FALSE whenever the value is NULL. (For other reasons, I can't add the default value on the source table itself.) Here is what I am doing.
CAST
(
CASE
WHEN bit_column IS NULL THEN 0
ELSE bit_column
END
AS BIT
) AS bit_column,
...
I have to do this on four columns, so I'm wondering if there is a better/more efficient way to do this.
use the isnull function.
isnull(bit_column, 0)
SELECT coalesce(bit_column,0) bit_column
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With