Jill,

The UNION performs implicit DISTINCT on the result set and it's not allowed for those type of fields. Change it to UNION ALL which doesn do DISTINCT.

>
>I am trying, and failing, to include a memo field in a UNIONed SQL SELECT. I've pared the statement down to the following:
>
>

>SELECT app_activitycomments ;
>	FROM appointments ;
>	INTO CURSOR c_Temp ;
>	WHERE !app_activity AND app_clientfk > 0 AND app_GroupnameFK=0 ;
>	UNION ;
>		SELECT app_activitycomments ;
>			FROM appointments;
>			WHERE !app_activity AND app_clientfk=0 ;
>			UNION ;
>				SELECT app_activitycomments ;
>					FROM appointments ;
>					WHERE app_activity
>

>
>and i get the error:
>
>"Operation is invalid for a Memo, Blob, General or Picture field"
>
>I can't have a memo in a UNION SQL SELECT statement?
>
>TIA, j