Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

case null SQL Server 2008

Tags:

null

sql-server

sql-server-2008

How to check for null in case statement in SQL Server 2008

like image 232
Rauf Avatar asked Dec 29 '10 07:12

Rauf

2 Answers

CASE WHEN column IS NULL THEN 1 ELSE 0 END
like image 197
Mitch Wheat Avatar answered Oct 07 '22 21:10

Mitch Wheat

Sometime you need case isnull(column, 99) when 99 then "null" when 1 then ....

like image 30
pinichi Avatar answered Oct 07 '22 22:10

pinichi
Sign in to Comment

Related questions

SQL: Join tables on substrings
How do I install Microsoft SQL Server for linux (fedora)?
Stored Procedure OUT parameter always returning NULL
Select the field as Distinct having data type as Text. Sql Server
SQL Insert Query With Condition
Create Geometry/Geography Field from Latitude & Longitude fields (SQL Server)
How can I get SSIS Lookup transformation to ignore alphabetical case?
Ranking Students by Grade in SQL
How to return all records if parameter is null
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count
Windows Azure, Entity Framework. Keyword not supported: 'metadata'.
Trigger to update table column after insert?
How to rename FK in MS SQL
Is a dynamic sql stored procedure a bad thing for lots of records?
Problem inserting string or NULL into SQL Server database
Are my issues with SSIS justified?
How to create a empty temporary table from another tables schema?
Why use JOIN rather than inner queries
"Ambiguous column name" error on one particular server
Create SQL 'LIKE' Statment that looks for specific Patterns of numbers and letters

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!