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)