NZ() is the best way to habdle nulls that you've never heard of! more CRUD operations on your database more Codeyou can run directly in LINQPad to create a conditional query more Sample code using PredicateBuilder to do an OR search using LINQpad more Code to run directly in LINQPad demonstrating PredicateBuilder usuage with Northwind's Categories table more Try this codeyou can run directly in LINQPad to create a google sitemap more Start here to explore some very useful LINQ queries - you can cut and paste into LINQPad more Codeyou can run directly in LINQPad to create a conditional query more This returns either the results for whole search term (if successful) or AND all the words in the search term and try that more |