Between

Field >='a' AND Field < 'г'

Field LIKE '[абв]%'

SELECT 'ё'
WHERE 'ё' COLLATE Cyrillic_General_BIN LIKE'[а-я]';
 
SELECT 'ё'
WHERE 'ё' COLLATE Cyrillic_General_BIN >= 'а' AND 'ё' COLLATE Cyrillic_General_BIN <= 'я';
 
SELECT 'ё'
WHERE 'ё' COLLATE Cyrillic_General_CS_AS LIKE'[а-я]';
 
SELECT 'ё'
WHERE 'ё' COLLATE Cyrillic_General_CS_AS >= 'а' AND 'ё' COLLATE Cyrillic_General_CS_AS <= 'я';

SELECT 'яяя' WHERE 'яяя' BETWEEN 'а' AND 'яя';