Following select causes wrong result, if is used collation SQL_Slovak_Cp1250_CI_AS or SQL_Czech_Cp1250_CI_AS.
select * from tab where col1 like 'CCI%'
If is used collation Slovak_CI_AS, SQL_Polish_Cp1250_CI_AS or other result is correct.
If is used nvarchar instead of varchar for column type result is correct.
If is used similar expression ( 'ZCI%' ) the result is wrong again.
This may be due to the different order of the letters in the Slovak or Czech alphabet. Leter order is A, B, C, D, E, F, G, H, CH, I, J ...
I tried the following versions SQL Server 2005, 2008, 2012.