Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 How to get true or false as result via select

Author  Topic 

cplusplus
Aged Yak Warrior

567 Posts

Posted - 2010-07-19 : 13:06:56
Is it possible to get true false bit type value as result from select query.

select from tab_users where myappsysDate < App_Exp_Date

Thank you very much for the helpful info.

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2010-07-19 : 13:16:31
One way is to use a CASE statement.
Go to Top of Page
   

- Advertisement -