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
-TomC