Basically, I am trying to write this psuedo-code in CAML.
(myList.Title = "Search String") AND
(myList.Field1 = "Some other string") AND
(myList.Field2 = "Yet another string" OR myList.Field3 = "Yet another string" OR myList.Field4 = "Yet another string OR myList.Field5 = "Yet another string")
I can't use LINQ because this is SharePoint 2007.
I have tried using U2U but it doesn't do the OR line in the query and returns nothing. Any help would be appreciated.