paul.j.kemna (8/4/2014)
When writing an expression in SSRS 2008 to check for blank values (NULL), is there any difference between Fields!FieldName.Value = Nothing and Fields!FieldName.Value Is Nothing? It seems that i have seen it both ways. I am currently using = Nothing and it seems to be working.Thanks
PK
Generally speaking, "equals nothing" or "= null" is not a proper expression in SQL Server or in any ANSI compliant relational database. You can't really compare "nothing" to something else. For example, you can say that a glass is empty, but you can say that a glass equals empty since the state of emptyness is not an exact measurement for comparison.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho