Is there anyway to get the select statement to notice that the string is too long for a straight text field and to convert it to a memo field when I run the following select command? I would expect the resulting table to have a memo field, but I don't get one, I get the error "String is too long to fit" instead. Win2K and VFP8.0 and all service packs.

create table junk.dbf (junk c(1))
appe blan
appe blan
m.junk = space(671)
SELECT m.junk FROM junk INTO TABLE junk1.dbf

TIA and out for the weekend.