>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.
Use &variable in place of (variable).