creating field aliases...

[duckyboyz]

does it matter whether you enclose the the alias name in quotes or not?

i.e.

SELECT Lname AS Lastname (no quotes)
from Personnel

or


SELECT Lname AS "Lastname" (double quotes)
from Personnel

or

SELECT Lname AS 'Lastname' (single quotes)
from Personnel


from Personnel

 

[jluckhoff]

For MSSQL any of your options will work

Same goes for Oracle if I rember right

Though the standard for ansi would be

SELECT column AS columnname FROM tablename

without any quotes

j

 

[nigelrivett]

For sql server (and access) it should be (but they will work) either

SELECT Lname AS Lastname
from Personnel

or

SELECT Lname AS [Lastname]
from Personnel


======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.