Sorting by names - is there anything to keep in mind?
for the HR dpt., I developed an app displaying various personell data - now I want to add the adoptions, that is, all those who were contract workers and have become permanent employees. These have two records in the masterdata table, but with a different number - only the name stays the same.
So I have to start by sorting the data I have by name.
That is why I ask, is there anything I should be thinking of when I sort by name?`Do I have to concatenate first and last name (and a possible middle name) into one string?
Re: Sorting by names - is there anything to keep in mind?
Yes you can concatenate the firstname and lastname and form a key. Change them to upper, since this will be case sensitive. Also in case the numbers for contract contain a different pattern you could consider that as well.