Fred ---
Just tested it....what I posted, when looking at result table structure DOES create a Memo (binary).
>
>There is no one code, but the following will work:
>
>CREATE TABLE mytable (mymemo M NOCPTRANS)
>
>The NOCPTRANS stops it from being evaluated through code page translation, effectively making the field a Memo (binary).
>
>>What's the code for CREATE TABLE when you want a Memo Binary type field?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05