Stephan after debugging your code <grin>, I've got it all working now. cheers - Jason Wong

SQL_Query (ZSQL Method):

Arguments:

table:string qry_criteria:string qry_column:string="specific" qry_item:string="general"

SQL Body:

<dtml-if "qry_column != 'specific' "> SELECT DISTINCT &dtml-qry_column; FROM &dtml-table; WHERE &dtml-qry_criteria; <dtml-else> SELECT * FROM &dtml-table; WHERE Status='Current' AND &dtml-qry_item; LIKE &dtml-criteria; </dtml-if>