I'm trying to group a transaction saved search by child customers under the top level parent, but I'm not sure what the SQL expression would be. If the customer name is 'Customer A : Customer B : Customer C' or 'Customer A : Customer B : Customer C : Customer D' I want to trim the name to 'Customer A : Customer B' and then group the results. Hopefully someone can help.