I want to learn SQL.

[Julian Milano]

Where's the best resource for learning SQL?

I want to know, for example, how to use the ALTER command to change the
property of a field, from TEXT to MEMO. I tried the Access HELP but there is
NO mention of the ALTER command??!!

 

[chas]

Hi Julian,

For Microsoft Access using JET SQL the links below are
pretty good.

http://msdn.microsoft.com/library/en-
us/dnacc2k/html/acfundsql.asp
(Fundamental Microsoft Jet SQL for Access 2000
)

http://msdn.microsoft.com/library/en-
us/dnacc2k/html/acintsql.asp
(Intermediate Microsoft Jet SQL for Access 2000)

http://msdn.microsoft.com/library/en-
us/dnacc2k/html/acadvsql.asp
(Advanced Microsoft Jet SQL for Access 2000
)

hth

chas