>>>But now that you bring it to *our* attention, in sql-selects I use single-letter aliases a lot and it has never harmed me in any way. The sql-select code is always in its entirety visible on the screen and the interpretation is easy enough. Moreover, a letter is neutral and allows changing the name of the used table more easily; in other cases the name of the used table is even unknown when programming.
>>>
>>>We've had some discussions on standards recently, as you probably know. I think that your statement is debateable. Perhaps this reaction is the offset for that debate. :)
>>
>>Peter;
>>
>>This may never happened to you but I know of several people who used A-J for an alias and it caused problems. This is something that goes back to dBase and could still be an issue. I have not tested it for some time but I never use a one letter alias - it is force of habit.
>>
>Tom,
>
>While using a single letter alias may not be a problem with either an SQL SP or when using SPT, using it in Fox is a terrible idea. This practice ties the code to a specific work area. Further, if a table is already in use in that work area, it is automatically closed.
>
>Of course, you know all this.:-)

Hello George and Happy Friday!

Life was so much simpler with dBase II with only two work areas. :)

By the way the Unos Pizza restaurant in Santa Clara closed. Now I guess I had better go to Chicago to get the real thing!

Tom