I need to add some program name listings from an external source to a list of constituents. Does anyone know the algorithm to generate the sort name field in tx_cust_program?
Thanks in advance.
-steve carlock
Santa Barbara Center for the Performing Arts/The Granada
Steve,
I guess it depends on what you want the value in sort_name field to be, where you're getting the other information from and how you're generating the data.
If I were doing it in SQL, I would probably get this from the T_CUSTOMER table - using the following logic to generate the sort_name:
upper(lname) + '/' + substring(upper(fname),1,1) as sort_name,