Hi, We are migrating from ORACLE to Vertica. In ORACLE we could do: Select acol from mytable Where year = FN_GET_YEAR And we had an ORACLE User Defined Function... (Not syntactically correct, just the main idea) Function FN_GET_YEAR Return varchar2 as Begin myyear varchar2(4); Select MAX(Year) into ...