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
 General SQL Server Forums
 New to SQL Server Programming
 Performing != on Decimal type

Author  Topic 

Velnias
Yak Posting Veteran

58 Posts

Posted - 2008-11-25 : 11:40:37
Hey I am trying to perform a != action on a decimal field but is not working where i have a null value in the DB how can i also include these values in my resultset.

Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-25 : 11:42:37
for nulls equality operators like =,!=,>... wont work
use field IS NULL or field IS NOT NULL instead
Go to Top of Page
   

- Advertisement -