>>Nope, you get a "String is too long to fit" error. The join with a one record table with a memo field is the only way I know that works.
>
>Oh well, it was just a guess, how about the CHR(13) idea?

No, that gives you a character field if the string is short enough and a "String too long to fit" error if it's more than 254 characters.