>>You may need to adjust the collating sequence to CaseInsensitive
>
>LIKE operator in SQL Server is case insensitive.
No, this is not true. It depends on database collation. If you're using case sensitive collation for the database, it will be case sensitive.
If it's not broken, fix it until it is.
My Blog 
