Blog

select 
    idx, 
    m_name, 
    m_id, 
    m_pmobile , 
    case when patindex('%[ㄱ-힇%]', m_pmobile ) > 0  then 'Y' else 'N' end as Hangul_YN 
FROM 
    member_tbl WHERE case when patindex('%[ㄱ-힇%]', m_pmobile ) > 0  then 'Y' else 'N' end = 'Y'