Some guy in the FOXPRO-L mailing-list asked for a funny thing:

He wanted to do a UNION SELECT between a memo-field and a Character field. Something like:

Select From tableX
Union Select From tableY.

To solve the problem I've replied with a function:

Function TransMemo(tmMemo)
Local I
Local RetVal

I = 0
RetVal = ""
For I = 1 To MemLines(tmMemo)
RetVal = RetVal + " " + MLine(tmMemo, I)
Next

Return RetVal

so that he could use as:

Select TransMemo() From tableX
Union Select From tableY

I warned him that this could be slow...
Does anyone have other ideas?

Alexandre Nobre
Alpha Bytes Computer Corp.

Did you know that there are innocent people dying in East Timor?
It helps if you do...

I suppose you don't need glasses if you're able to read this line