SQL 查找一个字段的首字母是以A~Z为首的数据
SELECT * FROM temp_bsp2016060304 t WHERE
(ASCII(SUBSTR(t.BSP_COMPANY_CODE, 1, 1)) > 64) AND (ASCII(SUBSTR(t.BSP_COMPANY_CODE, 1, 1)) < 91)
(ASCII(SUBSTR(t.BSP_COMPANY_CODE, 1, 1)) > 64) AND (ASCII(SUBSTR(t.BSP_COMPANY_CODE, 1, 1)) < 91)