Partitioning in SQL 2008 Boundary Wildcard?

[guest2013-1]

I've got a db with book ISBN's. I'd like to partition the table from 000 to 999 (based on the last 3 digits of the ISBN number)

Is there a way to wildcard the Boundary when setting it up through the wizard in SQL 2008? (ISBN is saved as a varchar field since some media, not just books, have letters in their ISBN definitions)

 

[guest2013-1]

I'm just thinking, would it work just as well if I created a new column that exclusively held the last 3 digits of the ISBN number and did the partition on that?

I'm thinking it might work...