maybe the following is worth reading:
http://vyaskn.tripod.com/case_sensitive_search_in_sql_server.htm>>So you've setup SQL server to be case insenstive? In that case you'll have to accept a index scan for that field. Whether that is going to affect performance beyond acceptable is something you need to test.
>
>SQL Server has been set up case sensitive. And, I am not the one who did it. What I need to preserve is the following those syntaxes:
>
>
>@Name="FOURNIER"
>SELECT Client.PrimaryKey FROM Client WHERE UPPER(Name) LIKE @Name
>
>
>
>@Name="Fournier"
>SELECT Client.PrimaryKey FROM Client WHERE Name LIKE @Name
>