>>Is there a way or a utility available to extract table names from a expression.
>>
>>The problem is expression can be any like
>>
>>Expr:
>>mytable.amount*yourtable.rate
>>
>>so it should return
>>mytable
>>yourtable
>>
>>Expr:
>>upper(mytable.testfld)
>>
>>Returns
>>mytable
>>
>>Pls advs your suggestions/ideas, its a very important think in my recent project..
>
>it is somewhat hard to know where a table name begins in (at least for the examples
>you gave you can find where each name ends with an AT() and other such commands

That is what the problem is.. I was thinking abt,searching the position of "." with AT function, then searching behind for a space or a non alphabate like comma or a bracket, but not able to program it properly..

Problem becomes more complex, when there is more then one table name..

>if there was a space before each table it would be easier
>note however that what ever you do will also return object names from expressions
>(e.g. for myobject.myproperty you will get myobject..)
>

I'm sorry but I was not able to follow your above point, Can you pls explain..