SPT (SQL Pass-through) statements are definitely the best way to go. At the shop where I am working at, we created a class to do this. Using the class, we populate the statement property either with a literal or from an SPT lookup table based on a numeric parameter which finds the appropriate SPT statement in the table.

>Hi,
>
>I have a VFP-database that is to be moved to SQL-server. For this database, I retriev some data from another VFP-database, other information is coming from flat files.
>The current procedures I have are X-base oriented. I could try and rewrite these using sqlexec etc., which is as far as I can get by now. I'm not sure if performance wille be good enough though. I would like to have some suggestions about which methods can be used to update a SQL-server database.
>
>Thanks,
>
>Auke