Auto incremented column in sql

Question

How to add the string and date values to auto incremented column while adding the record..the format should be  like  varchar+year+month+auto increment value