>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 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..) Arnon