Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  re: problem query with missing keyword

Author  Topic  msa969 Starting Member 13 Posts Posted - 2001-10-29 : 08:57:08 I am running Oracle8 database SQL> @p5q11.sql SELECT COUNT(empno) "Total", sum(CASE when hiredate='%83' then 1 else 0) as '1983' from emp * ERROR at line 1: ORA-00905: missing keyword I have tried other ways please help