Am 08.03.2018 um 12:56 schrieb Matthew Somerville: > You could do this: > > FixMyStreet::DB->resultset("Table")->search({}, { > columns => { col => \"left(col, length(col)-9)" }, > distinct => 1, > order_by => "left(col, length(col)-9)" }); Thank you VERY much!!! Andreas