한글 자음(초성) 으로 시작하는 문자열 검색하기.

select *
from 테이블
where case when m_stpdesc < 'ㄱ' then SUBSTR(m_stpdesc, 1, 1)
            when ascii('ㄱ') <= ascii(m_stpdesc) and
                 ascii(m_stpdesc)<= ascii('ㅎ') then m_stpdesc
            when m_stpdesc < '나' then 'ㄱ'
            when m_stpdesc < '다' then 'ㄴ'
            when m_stpdesc < '라' then 'ㄷ'
            when m_stpdesc < '마' then 'ㄹ'
            when m_stpdesc < '바' then 'ㅁ'
            when m_stpdesc < '사' then 'ㅂ'
            when m_stpdesc < '아' then 'ㅅ'
            when m_stpdesc < '자' then 'ㅇ'
            when m_stpdesc < '차' then 'ㅈ'
            when m_stpdesc < '카' then 'ㅊ'
            when m_stpdesc < '타' then 'ㅋ'
            when m_stpdesc < '파' then 'ㅌ'
            when m_stpdesc < '하' then 'ㅍ'
            else                  'ㅎ'
       end = 'ㄹ' ;    <<=================찾고자하는 자음


m_stpdesc <<===========해당 컬럼