None of my tables have a memo field. However I need to create a sql
statement combining fields from two of the tables and also include two memo
fields.

I know you can add other types of fields, e.g. SELECT space(50) as field1,
000.00 as field2, .t. as field3, etc

but I don't know how to use the same technique to add a memo field.

Is there a way of doing this within the statement itself, or must I create a
single record table containing a memo field, and then JOIN this in the
SELECT statement?

Many thanks

Stephen

Hello, Stephen!
You wrote on Tue, 7 Sep 2004 09:44:49 +0000 (UTC):

SI> I know you can add other types of fields, e.g. SELECT space(50) as
SI> field1,
SI> 000.00 as field2, .t. as field3, etc
SI> but I don't know how to use the same technique to add a memo field.
SI> Is there a way of doing this within the statement itself, or must I
SI> create a single record table containing a memo field, and then JOIN
SI> this in the SELECT statement?

Yes, that's how you would do it in the current versions of VFP. In the VFP9
beta, we can use the new CAST() function.
--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8

Thanks Eric

"Eric den Doop" <ericdendoop (AT) xspamblockxfoxite (DOT) com> wrote