>>>I have the select statement as follows:
>>> select * from table1 where table1.name = (variable);
>>>
>>>what I want to do is be abel to change table1.name based on what the user inputs. So how do I use a variable in place of table1.name.
>>
>>If table1 is a variable
>>then
>>
>>STORE (ALLTRIM(TABLE1)) TO TABLE1
>> SELECT * FROM &TABLE1. WHERE &TABLE1..NAME = variable
>>
>>should work.( Note the two periods)
>
>Thanks, using the & macro substitution is what I was missing.
//:^)