Auto-generated primary key in sql database based on other filled field

I would like to have unique generated primary key that will take info from other field to create that code. For example, let say I would like to generate student ID based on year, and student's name, so my code will consist of string that has 3 letter and 4 digit. Student name: Jone year: 2015 so the generated code will be something like: jon2015I would like to have unique generated primary k