Hi, i need to know what is difference in meaning of collate between this three queries FIRST and SECOND is accepted by server but THIRD return error "Invalid expression in the select list (not contained in either an aggregate function or the GROUP BY clause)" /* FIRST */ select w.wplata_nr_wyciagu collate PXW_PLK FROM WPLATA w group by w.wplata_nr_wyciagu order by w.wplata_nr_wyciagu /* SECOND */ select w.wplata_nr_wyciagu collate PXW_PLK FROM WPLATA w group by w.wplata_nr_wyciagu collate PXW_PLK order by w.wplata_nr_wyciagu collate PXW_PLK /* THIRD */ select w.wplata_nr_wyciagu FROM WPLATA w group by w.wplata_nr_wyciagu collate PXW_PLK order by w.wplata_nr_wyciagu collate PXW_PLK regards, Karol Bieniaszewski
