>>Make it
>>lvdate={04/09/1997}
>>SELECT claim_number FROM DEDUCTIONS WHERE voucher_date=lvdate
>
>Did the last solution work? Where you including the braces in the command just as shown in the example you gave. I have made the stupid mistake of having a table field name the same as the variable name and not putting a "M." in front of it.
>
>Arthur

Thanks, it worked fine. However, I have a bigger problem. I'm trying to execute an INSERT INTO sql command using a SELECT statement to provide the values of the INSERT INTO command. The sql worked fine in an IBM DB/2 database, at the runs fine when executed directly on the SQL Server. I've tried using SQLEXEC but it still doesn't work.

Jeff