Thanks Walter. This works fine for local views on foxpro tables. Unfortunately I I'm working with a remote data source (Access MDB). The SQL is compiled remotely in the database... not as flexible as foxpro, so no matter what I do it won't understand '&'

Thank again