>Any tips on how to query and join data from both character fields and memo fields (memo data < 256 char)? The ultimate objective is to create a tab delimited text file where each record includes the memo field data. Thanks, Tom.

If myTable has a charcater field cField1 and a memo field mField2, then you can

SELECT cField1, mField2 + "" as cField2 ;
from myTable;
into cursor myCursor

and myCursor.cField2 will be the contents of the memo field.