>hey everyone,
>i am trying to create an alias for table in a specified directory.
>
>how do i declare and alias and then set the alias = to the table.
>
>any suggestions would be appreciated. thanks.
>
>james

You don't have to declare anything...

SELECT 0 && Open next available workarea.
USE Path\MyTable ALIAS cMyTableAlias

OR

USE Path\MyTable ALIAS cMyTableAlias IN 0

Note: If you are from a UNIX environment, ALIAS is not the same thing as a UNIX system environment alias.