I have a field like this in a query:
This works, but every time I run the query, though it always functions, I also always get an error message:Code:IIF(flgNoSurvey = 1, Null, ISNULL(SomeIntegerField,0)) AS TotalNew
Error in list of function arguments: '=' not recognized.
Unable to parse query text.
What is causing that, and why bother when the query runs fine? Is this just telling me why SSMS can't diagram the query (which is actually a view, but it makes no real difference)?






Reply With Quote