Anybody know the logic behind creating the value Sort name in t_customer? Tried finding a function that is building it but don't see it. Since that column is only 55 characters, trying to figure out how many from the fname and how many from the lname.
Thanks,
Marty
Looks like it's all in AP_BUILD_SAL, based on rules from TR_SALUTATION_FORMAT. It does use a "@max_length = 55" for the sort_name.