[RESOLVED] referring to user defined column names in query

[edwardp]

i have a sql query that starts:

SELECT PART.ID, PART.DESCRIPTION, count(*) as number

i want to display al the results where number is greater than 1. But when i include the follwoing in the query, i get 'Invalid column name 'number''.

WHERE number > 1

if i can't refer to the given name of the count column, how do i refer to this column in the rest of my query??

Thanks in advance

[bogu]

SELECT PART.ID, PART.DESCRIPTION, count(*) as nr HAVING nr>1