• As far as I know this isn't possible in SQL Server.

    You could create a computed column that takes the first 5 characters of your column and put an index on the computed column.

    Indexes on Computed Columns

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP