Input Variable as parameter for SQL Select statement?

[#1]

Hi,

I've added an Input box to my sheet that contains a variable called CompanyID. How can I use that variable in my SQL Select statement, which is in my main script (File | Edit Script)? I've tried something like:

select * from company_lkup where company_id = @CompanyID;

but that didn't work.

Does anyone have an example?

Thanks,

Brian

[Anonymous · Accepted solution]

select * from company_lkup where company_id = $(CompanyID);

[#3]

Thanks Michael 🙂