SQL Server query combining fields into single field

I have recently changed over to SQL Server after using a MS Access database in my ASP pages.  I had a query in which I combined 2 field values into a single value for use in my pages.  When I changed over the SQL Server, however, the query doesn't work.  Below is the query as I wrote it for MS Access.  Is it possible to write this to work in SQL Server 2005?  And if so, what do I need to fix?

Chris Cote

SELECT dbo.tblClass.classID AS ID, [type] & ' ' & [class] AS Expr1 FROM dbo.tblClass ORDER BY [type] & ' ' & [class];

Select allOpen in new window