Folks, advice please as to why this SQL is failing: SELECT StringStart(d.[eventDate],4), count(1) as Records FROM <MySQLServerTable> as d GROUP BY StringStart(d.[eventDate],4) It does work (but does not group by) if I use the following, but that's not conforming SQL: SELECT StringStart(d.[eventDate],4), count(1) as Records FROM <MySQLServerTable> as d GROUP BY d.[eventDate] Works fine in SQL Server (using LEFT() in place of Stringstart()) (It's gonna be some simple error that I can't see) Thanks Greg
|