Using SQL as a variable

If I understand your question correctly, you will be able to use ADO (Active Data Objects) to access your SQL Server table. Google ADO for information. This is not a Test Complete or Smart Bear technology but Active X tech by Microsoft. Look ath teh connection object and the recordset object.