• Have you tried specifying the "Persian_" or "Persian_100_" collations

    e.g. select * from mtTable where theColumn COLLATE Persian_100_CS_AS LIKE '% ی%' COLLATE Persian_100_CS_AS

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”