I am trying to create a SQL Server 2008 View from an existing Table Students with the following Query it gives me an error mentioned below (Also attached)
SELECT Std_ID, Name, Sub1, Sub2, IIf ((Sub1 + Sub2)>160, 'A',IIf ((Sub1 + Sub2)>100, 'B','C')) As Legend FROM dbo.Student
Error in list of function arguments: '>' not recognized. Unable to parse query text.
I am expecting the view with the calculated field 'Legend'
Query execute perfectly in Query Designer but view is not created.