title: Creating a unique ID using first 3 character of last name and a sequence number
body: <p>I have this employee table which I want every employee to have a unique ID using the 3 first letters of their name plus a sequence number in SQL Server.
  I don't remember at all how to do this I haven't used SQL in a year and kinda forgot everything.
  Can anyone refresh my mind on how to do this. Google has been of no help on this matter. Thanks</p>