>Hi.
>
>I am trying to create a memo place holder in a SQL statement.
>
>Example:
>
>Select field1, field2, memo1 from table1
>union
>Select field1, space(1) as field2, space(?) as memo1 from table2
>
>What is the syntax to actually get the place holder for the memo field? I have tried a few things, but I keep getting a union incompatible statement.
>
>Any suggestions?
>
>Thanks in advance.
>
>Jennifer Ebenhoeh

Jennifer,

What you can do is to create a cursor with an empty field in.
Better is to hold an EmptyTable in your database so that it is always there.

create cursor EmptyCursor ;
  ( ec_m M default '')

insert into EmptyCursor(ec_m) values( '' )

Select field1, field2, memo1 from table1 ;
union ;
Select field1, space(1) as field2, ec_m as memo1 from table2, EmptyCursor