I am trying to write a query that will generate employee numbers. Employee number = first initial & first 7 characters of last name. UNLESS that is taken, then it's first initial, first 6 characters of last name, then the number 1. UNLESS that is taken, then it's first initial, first 6 characters...