James,

Is the Cust_Num field numeric? If not, you should put the value in single quotes, e.g.: "select * from customer where customer.cust_num = '1001'"

What error do you get (if any)?

>>>I am trying to complete the same type of function.
>>>I am using paradox table. I am able to connect to the table but can not run the following code:
>>>ndat=sqlexec(nConnect, "select * from customer where customer.cust_num = 1001", newdata)
>>>
>>>Do you know why this will not work?
>>>
>>>Thanks James
>>>
>>>
>>>