Toad World® Forums

Variables in automation - export data set

Just getting started with Toad - I'm trying to have a variable prompt ask for a phone number, query a table, then export the data to an excel spreadsheet

I have a query that works in the editor

    select * from PHONE_EVENT_HISTORY
    where PHONE_NUMBER like '%&phone%';

but when I run it through the automation designer/export dataset it seems to not pick up on the variable I set with a variable prompt. Am I approaching this wrong?