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)
--sb--