>>>
when a=1 and b=1 then 100 else when a=1 and b=0 then 50 ...
>>
>>Yep, Unfortunately T-SQL doesn't have logical data type
>
>Which is kind of ridiculous, because it has the bit type as a field. It's just that it treats it as unusable in expressions, unless you cast it as a, say, integer.
This works in T-SQL with no casting:
select * from store where active = 0
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.