Oooooohhhhhh... You're accessing the DBF via ODBC? You can still do a SP if you are using a DBC on the server. You would just use VFP code instead of the SQL code I gave. If you're not using ODBC you probably have a lot more options. So, I need a few more details to proceed:

Is there a DBC on the server?

What protocol are you using to access the data (i.e. ODBC)?

Can you access the DBF/DBC directly from code?

Can you have any code on the server?

Chad


>Because, this is a VFP DBF. I am not using SQL Server.