https://communities.sas.com/t5/SAS-Enterprise-Guide/Query-with-pure-EG-4-3-Query-Builder/m-p/37599#M4614 Maybe your case construct will work with a small adaptation. Use quotes like:<BR /> <BR /> case when "&amp;cond" ='' then 1=1 else &amp;cond<BR /> <BR /> Good luck. <BR /> - Jan. Fri, 25 Mar 2011 00:57:27 GMT jklaverstijn 2011-03-25T00:57:27Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Query-with-pure-EG-4-3-Query-Builder/m-p/37598#M4613 I am using the EG 4.3 query builder to select and filter data from dataset for generating report with parameter prompt.<BR /> <BR /> The parameter required will be ad-hoc SQL command e.g. year = 2009 and month = 1<BR /> <BR /> i able to perform such ad-hoc SQL when the parameter is entered, but get error when the parameter is left empty. I know there is an option for "Required non-blank variable" in the parameter prompt, by checking this the parameter cannot be left blank before submitting. But if i want to allow it to be blank, is there any workaround or trick for doing such magical query?<BR /> <BR /> I now assigned a "cond" variable for the ad-hoc condition and setting the filter = &amp;cond for performing such ad-hoc query. i have tried using case when &amp;cond ='' then 1=1 else &amp;cond end but fail with error.<BR /> <BR /> Any one has idea to this problem? Thanks in advance! Thu, 24 Mar 2011 10:10:08 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Query-with-pure-EG-4-3-Query-Builder/m-p/37598#M4613 SASDump 2011-03-24T10:10:08Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Query-with-pure-EG-4-3-Query-Builder/m-p/37599#M4614 Maybe your case construct will work with a small adaptation. Use quotes like:<BR /> <BR /> case when "&amp;cond" ='' then 1=1 else &amp;cond<BR /> <BR /> Good luck. <BR /> - Jan. Fri, 25 Mar 2011 00:57:27 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Query-with-pure-EG-4-3-Query-Builder/m-p/37599#M4614 jklaverstijn 2011-03-25T00:57:27Z