Let's say I have two tables, an Inventory Table and a Showroom table. Sometimes Inventory is used as a showroom display model and is transferred to a new Inventory batch with a dash and the showroom code after it. The showroom code is unfortunately a string and does not have a standard length. Is there a way to ask in a query to only show me Inventory that looks LIKE a showroom code (any showroom code). I have tried using LIKE and IN() to no success, and it seem like trying to make a criteria string in a function (Like *this* OR like *that* OR ...) never seems to work in the criteria box in the query builder(I'm sure that this has to do with LIKE being a reserved word and not text, so the criteria ends up looking for the word 'like'). I am down to doing my old standby of making a table by running through all Inventory with dashes and comparing that to all showrooms (my old friend Instr) and then creating a table but I wondered if there is some trick that I haven't run across to do this quicker and with greater elegance. I am using Access 2003. Thank you for your time and your replies.