Thanks Sergey,

SQL 2000 would actually do the trick then, using a computed column.

John


>
>AFAIK, you cannot use expressions in indexes, only column names. In SQL Server 2000, indexes also can be created on computed columns and views.
>