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...
**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.