>>>To return 'line' from 'orderdet.line' I am using the following code...
>>>
>>>test='orderdet.line'
>>>
>>>? substr(test,at('.',test)+1,len(test)-at('.',test))
>>>
>>>Is there a better way to do this?
>>
>>Joe,
>>
>>Try:
>>
>>? JUSTEXT(test)
>
>George, You're sneaky! I looked at that and assumed it was "only" for file names!

Yes, I am sneaky.< bg > Seriously, think about it for a second. How would VFP determine the difference between myfile.longext and mytable.field? Either one could be a file name or an alias and field name. Both are perfectly valid in either case. So...JUSTSTEM(test) would return the alias or the primary part of the filename. Just another twist.< s >