python ruby-programming-language Smalltalk Vue.js Knockoutjs TypeScript JavaScript, OOPs JavaScript Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 4 Angular 2 AngularJs 1.x NodeJs Perl Programming R Programming RequireJs Rust Programming Backbonejs closure programming language go-programming-language kotlin-programming-language
How to select true false based on column value in SQL Server?

How to select true false based on column value in SQL Server?

Hello everyone, today's I am going to share the query for  select true and false based on column value using the SQL CASE as given below.

CASE WHEN ColumnName IS NULL THEN 'False' ELSE 'True' END

In the below example, UNIT is a table name and UNITID, UNIT and UPDATEDATE is the columns name. Here I using the case on UPDATEDATE column.

For the detail you can see the example.

SELECT  E.UNITID,
    E.UNIT,
    CASE
        WHEN E.UPDATEDDATE IS NULL THEN 'NOT UPDATED'
        ELSE 'UPDATED'
    END AS RTURNING

FROM UNIT E

--OR

SELECT  MP.MASTERPLANID,
    MP.DISPLAYNAME,
            CASE
                        WHEN MP.MOBILENO IS NULL THEN 'False'
                        ELSE 'True'
            END AS ADDONS
             
FROM MASTERPLAN MP WHERE MP.EQUIPMENTID=8


Please see the live output as given in below screen.













Thank you!
ANIL SINGH

Hi there! Welcome to my blog. My name is Anil Singh. I'm a author of this blog. For more detail about me, kindly refer to this link..
My Blogs - http://code-sample.com and http://code-sample.xyz
My Books - Interview Questions and Answers Books- Get Your Book in 15+ Digital Stores Worldwide..

You Might Also Like
www.code-sample.com/. Powered by Blogger.
ASK Questions