Outputting BIT datatypes as a word? 1

[DSect]

Hello -

Is there an easy way to do a T-SQL SELECT statement and have the results return the word "YES" for 1 and "NO" for 0 for a BIT datatype column?

REPLACE can do one part of it, I think.. But, I'm not sure of how to do it for YES and NO.

Sample data:
------------------
1
0
0
1
0

Sample output:
------------------
YES
NO
NO
YES
NO




Thanks!

I'm just trying to save myself from doing some stuff @ runtime.

 

[DSect]

I'm sorry.. I searched improperly for what I was looking for.. I found it..

http://www.tek-tips.com/viewthread.cfm?qid=747849

Or like:

SELECT (CASE WHEN MyField = 1 'YES' ELSE 'NO') as MyOutput

THanks though for the board!!