I learned that the hard way yesterday. I love writing SP's for SQL2000. You get to re-learn SQL coding one more time after using the poor practices that VFP allows you to get away with.
__Stephen
>HAVING is only valid when you are using a Group By. VFP let you get away like this and treats a having with no group as part of the WHERE. In SQL you have to use the WHERE keyword for what you are doing.
>
>>>you can use CONVERT(int,
)
>>
>>I used :
>>
>>SELECT cast(g1csf.pacid /10000000 as int) as UREG, g1csf.*
>>into ProgeddTests
>> FROM g1csf INNER JOIN g1_cnsin
>> ON G1csf.cnsinv = G1_cnsin.cnsinv
>> where substring(ltrim(str(g1csf.pacid,14)),8,2) ='20'
>>and substring(ltrim(str(g1csf.pacid,14)),1,2) ='26'
>>
>>
>>any idea why a Having Clause cannot find the UREG column that is in position 1 of the table in a having clause?
>>
>>The last line of my SQL should read something like:
>>Having UREG >= 26000
>>
>>
>>__Stephen
