I would like to use CAML to write an efficient query to get all items in a list where a text field contains a value...
for example:
**ID Name**
123
234 Mr Rocket
345 Mr Science
In the query I want to the results to only include where items contain a value for the Name field.
Is there an easy way to do this? I don't want to iterate using object model (or LINQ), because this list is heavily populated.
Thanks