Hello, I am trying to create a unique identifier using parts of first and last name, DOB and Gender. I want the first 2 letters of the first_name & the first 2 letters of the last_name & last 2 letters of the last_name & DOB with no slashes & Gender as either M or F. For example: First_name Last_name DOB Gender ID_number John Smith 01/02/1995 M JOSMTH01021995M Mary Jackson 03/15/1975 F MAJAON03151975F Any help would be greatly appreciated!!
... View more