>By default, SQL Server’s use of indexes is case-insensitive
>
>You may also want to take a look at collating sequences.
>
http://www.sqlteam.com/article/using-indexed-computed-columns-to-improve-performanceThe only reason I added UPPER() expressions in VFP was to benefit of UPPER() searches and be optimized. In SQL Server, if I only have an index on Username for example, which was previously UPPER(Username) in VFP, will it still be optimized even when UPPER(Username) is used in a WHERE clause?