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?