MSSQL 한글 영문 구분

[한글컬럼값 들어있는 것만 지우기]
[sql]select *  from tbl where field like ‘%[가-힣]%’
delete  from tbl where field like ‘%[가-힣]%'[/sql]
[영문컬럼값 들어있는 것만 지우기]
[sql]select * from tbl where field like ‘%[A-Za-z]%’
delete from tbl where field like ‘%[A-Za-z]%'[/sql]