MS SQL Error

[AJBJ]

I am getting a mssql error,  below is the sql statement:

SELECT Products.Brief, (param 1) AS Cat, Max(IIf([Ext5] = 1 and [CFM] Not Like '%HD%',[Image],'00000')) AS FirstOfImage,

Count(Products.Seq) AS Qty

FROM Products WHERE ( ((Price)>0) AND ((Products.Cfm) Like '%Bath%') )

GROUP BY Products.Brief ORDER BY Products.Brief, Min(Products.Title)

The error is am getting:

Error Occurred While Processing Request

Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '='.

Any help with my query would be great.

Anthony

[BKBK · Accepted solution]

Wouldn't it be an idea to start with something like this?

SELECT Brief, (param 1) AS Cat, MAX(image) AS FirstOfImage, COUNT(Seq) AS Qty

FROM Products

WHERE Price > 0 AND Cfm Like '%Bath%' AND Ext5 = 1

GROUP BY Brief

ORDER BY Brief, Min(Title)