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