Sliktā ziņa - manis piedāvātais variants darbojoties tikai daļēji ;(

Šādam batcham:
select 'a' where 'ā' like 'a' COLLATE Latvian_CI_AI_WS
select 'c' where 'č' like 'c' COLLATE Latvian_CI_AI_WS
select 'e' where 'ē' like 'e' COLLATE Latvian_CI_AI_WS
select 'g' where 'ģ' like 'g' COLLATE Latvian_CI_AI_WS
select 'i' where 'ī' like 'i' COLLATE Latvian_CI_AI_WS
select 'k' where 'ķ' like 'k' COLLATE Latvian_CI_AI_WS
select 'l' where 'ļ' like 'l' COLLATE Latvian_CI_AI_WS
select 'n' where 'ņ' like 'n' COLLATE Latvian_CI_AI_WS
select 's' where 'š' like 's' COLLATE Latvian_CI_AI_WS
select 'u' where 'ū' like 'u' COLLATE Latvian_CI_AI_WS
select 'z' where 'ž' like 'z' COLLATE Latvian_CI_AI_WS

rezultāti ir:

----
a

(1 row(s) affected)


----

(0 row(s) affected)


----
e

(1 row(s) affected)


----

(0 row(s) affected)


----
i

(1 row(s) affected)


----

(0 row(s) affected)


----

(0 row(s) affected)


----

(0 row(s) affected)


----

(0 row(s) affected)


----
u

(1 row(s) affected)


----

(0 row(s) affected)