1. Mike Mackinnon

    Search Multiple Columns in Table - Best/Fastest Method?

    I am looking at doing a search through a custom table that has multiple fields for an item number. Example table fields: Item1, Item2, Item3, Item4, Item5, Item6, Quantity, Location, etc. I want to return ALL records that have an item number in any of the "item fields". Currently I have DD...