Hello,

I am writing a stored procedure where the tablename in a select statement can be variable.

In VFP I probably would use name substitution:

lcMyTable = "Users"
lcUser = "Christian"
SELECT * FROM (lcMyTable) WHERE Username = lcUser

In SQL that approach gives me problems, it either says "Must declare the table variable" or if I used a dynamic SQL Must delcare the scalar variable". I guess there is a simple approach but I just can't figure out what is the right one.