>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)