While using SQL execute with Case Statement, The keyword WHEN is not recognizing. The Below Error is coming
"SQL statement unrecognized keyword WHEN"
The SQL query as given below
SELECT [Material],[Value Unrestricted]
case
when [Material]>0 then 'h1'
end as Valuation
FROM [Sheet1$]
