>>Hello All,
>>
>>I would like to use a select statement to create a new table with an added memo field.
>>
>>
>>This creates a table but the pdf_file field is numeric 10 and I want a memo field.
>>
>>SELECT hip_no, MEMO() as pdf_file FROM stnhorse INTO TABLE hip nofilter
>>
>>TIA
>>
>>Jim Harvey
>>jharvey@hanoverpa.com
>
>You can join your table with another table that has only one record, and one memo field.
>
>HTH, Hilmar.


Thanks Hilmar, I just thought there was a way to do that in one step.

Jim