How to alter the boolean value in SQL Server select query?

Posted by Vikas on Stack Overflow See other posts from Stack Overflow or by Vikas
Published on 2010-03-06T06:00:47Z Indexed on 2010/03/08 0:52 UTC
Read the original article Hit count: 433

Filed under:
|
|

Basically I want to alter the boolean value selecting from the table:

e.g.:

SELECT otherColumns, not ysnPending FROM table

I need a column ysnPending = true if the value is false & false if the value is true.

Is there any function available to alter the Boolean value or I should use IIf or CASE...?

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about sql