• Out of curiousity. If one would like to get all strings containing a C from the below code... how would you do that in that collation?

    create table #t (string varchar (5))

    insert into #t (string) values ('ACH')

    insert into #t (string) values ('ACY')

    insert into #t (string) values ('AHHC')

    select string from #t

    where string like '%C%' -- will miss ACH

    drop table #t