How to use Boolean data type
Posted: Thu Apr 17, 2014 2:43 am
Can we use case statement on boolean datatype??
For e.g
case when COALESCE(test.Flag,'T') like 't%' or '%T%' then 1 else 0 end ;
here flag is a column in test table with boolean datatype.
I was trying to this in my etl and I was getting error.
Thanks;
For e.g
case when COALESCE(test.Flag,'T') like 't%' or '%T%' then 1 else 0 end ;
here flag is a column in test table with boolean datatype.
I was trying to this in my etl and I was getting error.
Thanks;