Microsoft SQL server 6.5 to 2005

Hi Fellas,
I would really appreciate if you could help me out with the following two questions?
1) Can 2005 server files be converted to 6.5? and how?
2) How easy it to upgrade from 6.5 to 2005? and how?
I would be really grateful by your help
NickNot so easy task to do as you have to compare each and every aspect of the database to ensure they work in compatibility of SQL 2005.

Refer to http://sqlserver-qa.net/blogs/tools/archive/2007/04/12/set-a-stage-for-smooth-upgrades-of-your-sql-server-environment.aspx & http://sqlserver-qa.net/blogs/tools/pages/easy-way-to-upgrade-from-previous-version-of-sql-server.aspx in this case.|||Thanks a lot, i appreciate.|||Maverick

I should imagine it would depend on the size & complexity of the 6.5 DB

For a simple DB I would probably just script out the Schema then, run script & right click - import the data on the 2005 box then - suck it & see fixing any issues (IF there are any) in testing.

Or you could spend your life reading up on the possible failures & effects that may occur as Satya suggests

GWsql

Microsoft Access Query converted to SQL

Here a query Microsoft Access Query That I would like to convert to SQL. What replace the Word "Last" in SQL

SELECT Contacts.FirstName,Last(Contacts.LastName) AS LastofLastName
FROM Contacts
GROUP BY Contacts.FirstName;

You can try a ORDER BY on lastname column with TOP 1 or Max(LastName).

SELECT Contacts.FirstName,Max(Contacts.LastName) AS LastofLastName
FROM Contacts
GROUP BY Contacts.FirstName

Or

SELECT TOP (1) Contacts.FirstName, Contacts.LastName AS LastofLastName
FROM Contacts
ORDER BY Contacts.LastName DESC

|||Thanks. It works fine on both.