What is the best way to associate a string field FullName, that was created using:
Upper(Trim(lastname)) & ' ' & Upper(Trim(firstname)) as FullName
from two tables?
I also tried converting it to: Upper(Trim(FullName)) as FullName
within a preceding load
Resulting in no FullName matches where there should 25
Any ideas out there?