Is there a list of the syntax for the WHERE ? I tried WHERE substr(name,1,1)='A' and it threw an error; also where date GT '01JAN2016'D didn't work.