Incorrect Yntax near AS

Question

Plz help me to rectify the error:

Error: Incorrect syntax near the keyword 'As'.

Code:

declare @flag as int;
SET @flag='1';
SELECT Ci.iInstNumber AS InstNo,Ci.dInstDate AS InstDate, CASE WHEN (@flag='1')THEN SUM(Ci.fInstAmount+Ci.fShareProfit) ELSE Ci.fInstAmount As InstAmount END

Shivanand Arur · Answer

Hello Anil please remove the 'as' keyword you have written after the declare @flag statement... Code: declare @flag int; SET @flag='1'; SELECT Ci.iInstNumber AS InstNoCi.dInstDate AS InstDate CASE WHEN (@flag='1')THEN SUM(Ci.fInstAmount+Ci.fShareProfit) ELSE Ci.fInstAmount As InstAmount END Anil please mark the answer as accepted if it helped!!! Thank you.