21 reputation
1
bio website
location
age
visits member for 2 years
seen Nov 6 '12 at 20:02

Oct
25
comment Select one name per person where spelling variations exist
Thanks to all for all the help! it's greatly appreciated!
Oct
25
comment Select one name per person where spelling variations exist
the source system is a user input system... so, the employee ID is entered correctly (most of the time) but the employee name can be entered differently depending on how much info the person entering the data enters (i.e. includes middle initial or not). I have no control over the source system. I'm just trying to clean up the data prior to actually using it.
Oct
24
comment Select one name per person where spelling variations exist
That worked!!!! :) Thank you so much!!! I should have posted the question hours ago instead of wasting so much time! Thanks again! Have a great night! :)
Oct
24
awarded  Student
Oct
24
comment Select one name per person where spelling variations exist
That is correct, there is always a comma between the last name and the first name. However, I was hoping i could use the Emp_ID column to get my unique list and then bring in the name associated with that ID... problem is that in many cases i have multiple names (albeit the same person) associated with that ID. --And yes, it's always: LastName, FirstName sometimes it's LastName, FirstName, MI
Oct
24
asked Select one name per person where spelling variations exist