>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.

In SQL Server it should be

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

If you want the same code to be used in both VFP and SQL Server you can do

select * from (select COUNT(DISTINCT(WO_NUMBER)) AS TOT_NUM from MyTable WHERE <SomeCondition>) X
WHERE TOT_Num > 5