You can partition by creating a persisted computed columns.

https://msdn.microsoft.com/en-us/library/ms186241.aspx

Excellent Article! Step by step details with snapshot that makes it easy for the first time user. Including all the details.

Keep it up!

Deepa