[T-SQL] 첫글자로 검색하기 (UNICODE)

SELECT LEFT(mNameKor, 1), mNameKor 
FROM material 
WHERE mNameKor >= '가' 
AND mNameKor < NCHAR(UNICODE('가') + 588)

아 참고..

'가' + 588 = '까'
'까' + 588 = '나'
'나' + 588 = '다'
...