Aaron,

select x1.*, cast( null as m ) as MyMemo ;
   from x1 ;
   into cursor x2 readwrite

>I forget how to add a memo on querying a SQL table?
>
>Select *, memo from tableA where caseno LIKE ?caseno
>
>in which memo is not existed in table A, but it is a only EMPTY memo field added for data manipulation.