Select case in sql server

Question

question

asmasm asked Sep 25, '16

Select case in sql server

Dear all Please let me know why i'm not getting same results in below cases how to achieve without third variable declare @TaxName VARCHAR(30)=NULL, @StateCode INT=0 select @TaxName=NULL SELECT TaxId,TaxName,TaxPercent,StateCode from Taxes WHERE Active=1 and TaxName = ( case when TaxName =NULL then TaxName else @TaxName end) go SELECT TaxId,TaxName,TaxPercent,StateCode from Taxes WHERE Active=1 and TaxName = TaxName It should give same output.

select case-statement

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2016-09-25T15:27:31Z

ThomasRushton answered Sep 25, '16

NULL. Don't use = when looking for NULL values, as NULL isn't a value you can compare (even with NULL)... Use, for example, CASE WHEN TaxName IS NULL instead of CASE WHEN TaxName = NULL Have a look at Robert Sheldon's Simple-Talk article "[How to Get NULLs Horribly Wrong in SQL Server][1]" [1]: https://www.simple-talk.com/sql/t-sql-programming/how-to-get-nulls-horribly-wrong-in-sql-server/

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

asmasm commented · Sep 27, 2016 at 03:53 AM

Oh my bad. :)

0 ·

question