I tested it with ODBC from VFP.

>But will this work with ODBC call, the last one though worked well in VFP couldn't be ODBCed
>
>>>Hi Sergey
>>>
>>>Thanks for your help, the following is the final creation from your suggestion and I have put it in the Stored Procedures for view to access it, but there is a problem leter on:
>>
>>I couldn't get it to work either but following version works.

LPARAMETERS lcLn
>>LOCAL lcStr, lcOldArea
>>lcOldArea = SELECT()
>>lcStr  = ""
>>IF NOT USED("test0")
>>	USE test0 IN 0
>>ENDIF
>>SELECT test0
>>SCAN FOR ln = lcLn
>>	lcStr = lcStr + " " + sn
>>ENDSCAN
>>SELECT (lcOldArea )
>>RETURN PADR(ALLTRIM(lcStr),32)