>Hi,
>
>The SQL Select I have that works with VFP does not work with SQL Server database. The SQL statement has HAVING clause. For example (simplified) the following does not work with SQL Server database:
>
>

>select COUND(DISTINCT(WO_NUMBER)) AS TOT_NUM from MyTable WHERE <SomeCondition> HAVING TOT_NUM > 5
>

>
>The error is Invalid Column name TOT_NUM. How would I change the above SQL Select make the HAVING working?
>TIA.

select COUNT(DISTINCT WO_NUMBER) AS TOT_NUM
       from MyTable
WHERE <SomeCondition>
HAVING COUNT(DISTINCT WO_NUMBER) > 5