how to append few leters of text with primary key

Nov 5 2012 1:03 PM

i have one table in sql 2005 which stores emp_code,emp_name....

emp_code should take first 2 letters of emp_name and some number should be attached(eg:-om1,ra2)

how should i achive this.
pls help