HANTERM 은 컬럼명..
select *
from 테이블
where case when HANTERM < ‘ㄱ’ then SUBSTRING(HANTERM, 1, 1)
when ascii(‘ㄱ’) <= ascii(HANTERM) and
ascii(HANTERM)<= ascii(‘ㅎ’) then HANTERM
when HANTERM < ‘나’ then ‘ㄱ’
when HANTERM < ‘다’ then ‘ㄴ’
when HANTERM < ‘라’ then ‘ㄷ’
when HANTERM < ‘마’ then ‘ㄹ’
when HANTERM < ‘바’ then ‘ㅁ’
when HANTERM < ‘사’ then ‘ㅂ’
when HANTERM < ‘아’ then ‘ㅅ’
when HANTERM < ‘자’ then ‘ㅇ’
when HANTERM < ‘차’ then ‘ㅈ’
when HANTERM < ‘카’ then ‘ㅊ’
when HANTERM < ‘타’ then ‘ㅋ’
when HANTERM < ‘파’ then ‘ㅌ’
when HANTERM < ‘하’ then ‘ㅍ’
else ‘ㅎ’
end = ‘ㄴ’ <–이 부분이 검색을 하고자 하는 ‘ㄴ’ 으로 시작하는 문자열 검색 부분.
