On 4 March 2016 at 18:03, Greg Keogh <[email protected]> wrote: > Folks, anyone using Azure Tables Storage in anger? I really like it, simple > and effective. > > What is the query syntax equivalent of SQL "not null", that is, a row has a > named property? I have a table with tens of thousands of rows, but only a > small percentage contains a property value named ErrorMessage, and I want to > select them only. Going ErrorMessage neq "" works but it's too ugly to > believe there isn't a better way.
OData has a "null" literal, but I don't know if they have it in Azure Tables (I have not used it "in anger"). Have you considered including something in the RowKey so that you can distinguish these rows from the rest with a range query instead? -- Thomas Koster
