Syntax for where column is null

[S]

Hi,

I am trying to write a condition where I need to return all rows in a table where a particular column is either blank or null.

I am using the following code:
     String condition;
                    condition += @" (CustomerId == """ + ItemObject.CustomerId  + @""" or CustomerId   is null)";

Its not working. Can someone help me with some syntax that I can use?

Thanks,
Maggi

[Ady]

Hi Maggi,

 Are you using LINQ or OQL or plain SQL? What is the data type of the column? If you are using LINQ and it is a character column you could write something like
var q = context.YourType.Select( t => string.IsNullOrEmpty(t.FieldName))

Do let me know if this helps or else some more information on the exact use case would help in providing a more specific answer.


All the best,
Ady
the Telerik team