Hi John,
off the top of my head in VFP7, you would need to do a two part process to achieve this. One way is to create a one record table with a blank memo field and add that field into your original query, then process the concatenation of the memo fields into this blank field after your SQL has run.
In VFP9 you may be able to use the CAST() function for this (but have only read about it so I'm not positive).
>I have 4 memo fields: Dispatchers Notes, Technician Notes, Billing Notes, and Parts Notes.Most of these are empty most of the time. Ocasionally, there will be a note in one or two and very rarely in all four.
>
>I have a function that takes all four memo fields and returns:
> Dispatcher: + Dispatches Notes
> Technician: Technician Notes
> Billing: Billing Notes
> Parts: Parts Notes
>
>When I use the function as a field parameter for a SQL Select, I sooner or later get a "string is too long to fit" error.
>
>If the Select were trying to put the results of the function call into a memo field, it wouldn't be a problem but, it is clearly attempting to put it into a characte field.
>
>Is there any way around this problem in VFP 7.0?