Posted by Erland Sommarskog on 07/30/06 08:26

(jim_geissman@countrywide.com) writes:
> Oops, I forgot the follow-up....
>
> If I were to create such a computed column index based on the column
> with the non-alphanumerics squeezed out, and were to query against
> @variable that also had the non-alphanumerics squeezed out, I suppose I
> would need to use an index hint to ensure that index was utilised?

No, you should not have to. But you have to ensure that a number
of SET commands are in the right position. Most important, beware of
SET ARITHABORT which must be ON for SQL 2000, but which is never ON
by default, except in Query Analyzer.

-
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]