Hi Ali,
I'm glad you got it to work. I guess you figured out that there was
NOT missing in
WHERE clause in code I posted. Sorry about that.
>Hi Sergey,
>
>Thank you very much. It worked.
>
>By the way, I appreciate your tips.
>
>Have a great week,
>Ali
>
>>>
>>Ali,
>>
>>I still not sure what the problem is but thre're a couple things you can change in your query. First, strip trailing spaces from the value passsed to FULLPATH() function. Second, Pad result of FULLPATH() function so it wouldn't be truncated. Third, use EMPTY() function to check if field is empty. If you want it be rushmore optimizable, you can change it to
WHERE TableNames <> SPACE(LEN(TableNames))SELECT Distinct PADR(fullpath(ALLTRIM(Names),60) AS FileNames ;
>> FROM MyTable ;
>> WHERE NOT EMPTY(TableNames) ;
>> INTO CURSOR Tables
--sb--