Hi I am trying to compare two fields in different tables and I need to do a like because it is searching for specific characters in the whole field. I've got - like "*[tablename].[fieldname]*". Unfortunately the " marks will make it look for whatever is inside it rather than in the table itself. Does anybody know a way round this? I hope I've made myself clear!