Sergey:

Thanks it seems to work perfect with SQL Server. I trying to tie out two systems. One written with SQL Server and One with FoxPro. This code seems to work only with SQL. i guess foxpro doesn't support the type of join that you provided.

Any idea's on how to solve this in SQL with Foxpro. I know I can scan through a table, but I'd rather use SQL statements.

Thanks,
Steve