IF gcFunction = '001' sqlexec(handle, 'select * from p1', 'p1') ELSE sqlexec(handle, 'select * from p1 where p1_funckey = {gcfunction}', 'p1') ENDIFIn other words, I want all records if the value of gcFunction is '001', otherwise I want to filter for p1_funckey equaling the value of gcFunction. I have already tried a variety of IIF() constructs in the where clause, but that doesn't work. How do I do this?