[rever75]

I am trying to create a view that has a case statement.

CREATE OR REPLACE FORCE VIEW RCPTINFO" ("ORDRNO", "LINENO", "InvNO", "RCPTDT" "RCQTY) AS
SELECT rcord AS ordrNo,
rclin AS lineNo,
rcInv AS InvNo,
rcdat AS rcptDt,
CASE
If rclen > 0
then rclen AS RCQTY
Else
rcwgt AS RCQTY
FROM SalesInfo

I keep getting an error about From not being found or in right place. Any help would be greatly appreciated.

[Ossian]

What database software is this in please?
You appear to be missing the END keyword when the case has finished, i,e. immediately above the FROM line
Also missing a close quote after RCQTY in the first line

Here is an example of a working CASE Statement:

SELECT Top 1000 TOa, CC, "TestCase" =
CASE 
	WHEN RFC822_size > 20000 THEN BACKUP_date
	ELSE PP4_MAILBACKUP_ID
END
FROM PP4_MAILBACKUP