SELECT * FROM STATE_LIST WHERE STATE_ABBREV = '#Session.bm.state_list#' SELECT * FROM STATE_LIST ORDER BY SORT_ORDER SELECT * FROM STATE_LIST WHERE (STATE_ABBREV != 'DC' OR STATE_ABBREV != 'PR') ORDER BY SORT_ORDER

Statistics Chart

Please Select A Valid State.

Please Select A Valid Chart Type.

SELECT #Session.bm.chart_type# AS X_VAL FROM #all_state_list# #us_state_list# #Session.bm.state_list# GROUP BY #Session.bm.chart_type# ASC SELECT COUNT(#Session.bm.chart_type#) AS Y_VAL FROM #all_state_list# #us_state_list# #Session.bm.state_list# WHERE #Session.bm.chart_type# LIKE '%#searchString#%'

SELECT COUNT(#Session.bm.chart_type#) AS Y_VAL FROM #all_state_list# #us_state_list# #Session.bm.state_list# WHERE #Session.bm.chart_type# LIKE '%#searchString#%'