I am going against a V9 Progress DB using ODBC on Windows with Brio. I have available the functions 'LEFT' and 'UCASE' which I need to use. I can use either one with success but if I try to nest these I get a GROUP BY error or syntax error. I have tried many ways with no success. Is there a work around?