To get around it, I'll have to use what I was doing - which is setting up a SQL_STR and executing the SQL_STR. That makes sense. Glad you guys were here to help me figure this out. Couldn't do it without you. ;) Chris On Fri, Jan 31, 2014 at 12:39 PM, Chris Taylor < christopherdtaylor1994@xxxxxxxxx> wrote: > So let me guess.....even though the IF BLOCK would work on EXECUTION, it's > FAILING during compile because I'm specifying the COLUMNS for > &&p_table_name? > > Is that what's happening? If so, any suggestions to get around it? > > Chris > >