Issues with SQL comparison and null values

by

The problem is with NULL comparison. If a.field1 or b.field3 is NULL you need to use a IS NULL or IS NOT NULL statement. You could use a default value for a.field1 and b.field3 with the ISNULL function.

ISNULL(a.field1,0) <> ISNULL(b.field3,0)

in this case there is a comparison with the value 0.

SELECT IIF(NULL=NULL,'true','false')  -- The result is false.  Amazing!

More Related Contents:

  1. Efficiently convert rows to columns in sql server
  2. How can I get column names from a table in SQL Server?
  3. How can I select the first day of a month in SQL?
  4. Multi-statement Table Valued Function vs Inline Table Valued Function
  5. SQL Server Insert if not exists
  6. Select statement to find duplicates on certain fields
  7. Using a Variable in OPENROWSET Query
  8. How to find current transaction level?
  9. How do I see active SQL Server connections?
  10. Check for file exists or not in sql server?
  11. UPDATE if exists else INSERT in SQL Server 2008 [duplicate]
  12. How to cast variables in T-SQL for bulk insert?
  13. How to create a PivotTable in Transact/SQL?
  14. Group DateTime into 5,15,30 and 60 minute intervals
  15. concatenate two database columns into one resultset column
  16. Is there a SELECT … INTO OUTFILE equivalent in SQL Server Management Studio?
  17. Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
  18. T-SQL and the WHERE LIKE %Parameter% clause
  19. Custom aggregate function (concat) in SQL Server
  20. Which SQL query is faster? Filter on Join criteria or Where clause?
  21. Generate all combinations in SQL
  22. UPDATE and REPLACE part of a string
  23. Generate random int value from 3 to 6
  24. Improve SQL Server query performance on large tables
  25. The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range?
  26. Average of multiple columns
  27. Show all rows that have certain columns duplicated
  28. How do I find the data directory for a SQL Server instance?
  29. Safest way to get last record ID from a table
  30. SQL server, Converting Seconds to Minutes, Hours, Days

Leave a Comment