>>Unfortunatly, it is not up to me to change the data structure. I know it is not the best structure, but I have to work with it. Normalizing the current table into a temp data sounds very do-able, although I'm not sure how that would be done. Any suggestion?
>>THANKS!!
>

>Select "1" AS something, t1 As Tn, Goal1 AS Goal ;
>  FROM table1 ;
>Union All ;
>Select "2" AS something, t2 As Tn, Goal2 AS Goal ;
>  FROM table1 ;
>Union All ;
>Select "3" AS something, t3 As Tn, Goal3 AS Goal ;
>  FROM table1 ;
>INTO CURSOR crsNorm
>
>SELECT Tn, Goal From crsNorm;
>  WHERE Tn In ( SELECT Max(Tn) From crsNorm)
>
>

In different circumstances, I've had a problem numeric fields in UNIONS providing the full size of the field required. The first actual data that the SELECT finds seems to determine the size.

I played around with a way of enhancing the UNION above, and it may be a workable approach in other situations.

Include the following clause:

UNION ;
SELECT "0" as something, 0000000 AS tn, 0000000 AS goal ;
    FROM table1 WHEN .F.

Jay