Jack, the UNION worked -- no errors, Thank you! However, after looking at the result I realize that I need to 'AND' the two criterial not 'OR' them.

My original query should read

[font="Courier New"]SELECT M.modelid

FROM dbo.Models AS M

INNER JOIN dbo.ModelAttributes AS MA

ON MA.ModelId = M.ModelID

WHERE

(MA.AttributeID = 29 AND (CONVERT(NVARCHAR(128),MA.Value) LIKE '%IL%') )

AND

(MA.AttributeID = 7 AND (CONVERT(DECIMAL(10,5),MA.Value) >= 0.0360 AND CONVERT (DECIMAL(10,5),MA.Value) <= 0.0840))

AND

(M.ProductID = 2)[/font]

I tried variations of UNION but I don't think that is what I need. Can you suggest an alternate to the UNION query that will work in this case?

Thanks in advance