select distinct SRI
FROM  roads_2009_midyear_6_8_2010 a 


 WHERE FUNCT_CLASS <> '9'
  AND FUNCT_CLASS <> '19'
  AND FUNCT_CLASS <> '8'
  AND FUNCT_CLASS <> '0'
  AND SRI NOT LIKE 'R%'
  AND SRI NOT LIKE 'T%'
  AND SRI NOT LIKE 'C%'
  AND SRI NOT LIKE 'N%'
  AND SRI NOT LIKE 'L%'
  AND SRI <> 'I0000095__'
  AND SRI <> 'I0000095_S';