210 : <cfif session.KeywordSearch6 is "S">and NOT WLOTS.SYMBOL LIKE '%C%' </cfif>
211 : <cfif session.KeywordSearch6 is "C">and ((WLOTS.SYMBOL LIKE '%C%' or WLOTS.SYMBOL_PHX='Y') or WLOTS.FIRM_ID='ZL')</cfif>
212 : <cfif session.FromDate is not ""> and (WLOTS.Last_edit >= '#session.FromDate#')</cfif>
213 : GROUP BY MAJGROUP, CATDESCR, SUBGROUP
214 : ORDER BY MAJGROUP, CATDESCR, SUBGROUP
|