• No problem.

    It's not made clear, but it is on the MSDN page for CREATE INDEX http://msdn.microsoft.com/en-gb/library/ms188783(v=sql.105).aspx

    The important lines are below, note in the filter_predicate part only AND is allowed, not OR.

    You can see from the comparison_op list that LIKE isn't allowed either.

    [ WHERE <filter_predicate> ]

    ...

    <filter_predicate> ::=

    <conjunct> [ AND <conjunct> ]

    <conjunct> ::=

    <disjunct> | <comparison>

    <disjunct> ::=

    column_name IN (constant ,...n)

    <comparison> ::=

    column_name <comparison_op> constant

    <comparison_op> ::=

    { IS | IS NOT | = | <> | != | > | >= | !> | < | <= | !< }

    Cheers