205 : <cfif session.KeywordSearch6 is "S">and NOT WLOTS.SYMBOL LIKE '%C%' </cfif>
206 : <cfif session.KeywordSearch6 is "C">and ((WLOTS.SYMBOL LIKE '%C%' or WLOTS.SYMBOL_PHX='Y') or WLOTS.FIRM_ID='ZL')</cfif>
207 : <cfif session.FromDate is not ""> and (WLOTS.Last_edit >= '#session.FromDate#')</cfif>
208 : GROUP BY MAJGROUP, CATDESCR, SUBGROUP
209 : ORDER BY MAJGROUP, CATDESCR, SUBGROUP
|