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.
| Author |
Topic |
|
vicky0382
Starting Member
3 Posts |
 Posted - 2009-06-01 : 12:27:15
|
| I want records of fields that contains Null,How it possible using Filter. |
|
|
osirisa
Constraint Violating Yak Guru
289 Posts |
Posted - 2009-06-17 : 13:12:03
|
| #4: Finding or excluding null valuesOnce you decide that null values are acceptable, it's your job to accommodate them throughout the application. To find or exclude null values, use Is Null and Not Is Null, respectively, in criteria expressions and SQL WHERE clauses. For instance, to find null values in a query, you'd enter Is Null in the appropriate field's Criteria cell. When building a WHERE clause, use Is Null and Not Is Null as follows:WHERE source.field Is NullWHERE NOT(source.field) Is NullI hope this Helps You Vicky !!!! |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-17 : 13:21:53
|
quote:
Originally posted by vicky0382
I want records of fields that contains Null,How it possible using Filter.
just use filter as=Fields!YourField.Value = System.DBNull |
|
|
|
|
|
|
Filter record for Null