That is a column alias. It can be anything you'd like it to be.
Ex:
SELECT C.[description] AS [!]AnyAliasName[/!]
FROM tbl_PMS_CLR C
SELECT C.[description] AS [!][My Happy Little Alias][/!]
FROM tbl_PMS_CLR C
In your front end code, when you refer to columns, it is usually done by alias name. Without an alias, the column name is used. So... in VB, it would look something like...
debug.print RS.Fields.Item("Application").value
Since 'application' is just an alias, the values shows are really from the description column.
Make sense?
-George
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
Application just looked i little too specific to be just an alias. I have used aliases before but thought that 2005 may have had something different as it showed up in BLUE.
Thanks for the quick response.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.