>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