Steve,

Try

SELECT fvdwg AS dwg FROM mytable ;
UNION
SELECT fhdwg AS dwg FROM mytable ;
INTO CURSOR crsResult

>I'm not sure what the best way to do this is. Can it be done with select-sql?
>
>I have a table with 2 fields. One field contains Customer drawing names, the other contains vendor drawing names, Both are character fields c(30).
>mytable.fvdwg
>mytable.fhdwg
>
>I want to build a cursor that contains all fvdwg's and all fhdwg's and no duplicates, in one field. mycursor.fdwg
>
>Can we merge 2 fields into one with select-sql or will I have to use traditional methods, create cursor, insert etc...