Try
SET ENGINEBEHAVIOR 80
SELECT GtType DISTINCT FROM VWXLTBL ORDER BY PK INTO CURSOR VWXLTBLID
>if i include the PK field then i do not get the distinct values, just using order by gives me an error.
'If the people lead, the leaders will follow'
'War does not determine who is RIGHT, just who is LEFT'