Hi,

With SQL server using 1/0 for logical values ... if I want to return a real "logical" value, how do I do it? If I just select 1 or 0, it is coming across as the integers 1 or 0.

For example: "Select 1" returns the integer 1. I'm currently using "Select cast(1 as bit)" which works, but seems awkward - there's got to be a better way.

TIA!