Hi Jason ---

Yes. Assume cTable = "voters" and cTableCol = "voters.state"
The SQL becomes:

SELECT * FROM &cTable WHERE &cTableCol = ?lnparentid


>Hello everyone --
>
>My question revolves around the creation of an sql select statement. Can I set a variable on the left hand side of the = sign on a WHERE statement?
>
>I have been able to set the name of a known table and field = to a variable.
>
>Example:
>
>Where voters.state = ?lnparentID
>
>This I have done. I have been able to set the variable equal to a specific table and field and requery the pview to make such a statement work.
>
>However, Let's say I don't know value of what is located in the fieldname I am interested in until run-time. In this case, can I set a variable for the table.fieldname in my WHERE statement?
>
>To sum up> Can I set a variable on the left hand side of the equal sign in my WHERE statement to look at the value for a specific table.fieldname, which is not known until run-time?
>
>Very curious!
>
>TIA for any insight into this question
>
>Jason