Display Multiple Columns Into One Column

My first ASP.NET/SQL project. I'm creating an Asset Management DB. I wish to view the Asset number, the full name of the user it's assigned to and the Make and Model of each record in the DB. However assets are split into different categories e.g. monitors, PCs, Preinters etc. and they are all in different tables. The SQL below displays the asset number, Name of person assigned and the model of the asset.

SELECT Hardware.AssetNo, [User].FullName, MonitorModel.Model, PCModel.Model AS Expr1, PrinterModel.Model AS Expr2

FROM Hardware INNER JOIN

[User] ON Hardware.UserID = [User].UserID INNER JOIN

Model ON Hardware.ModelID = Model.ModelID LEFT OUTER JOIN

MonitorModel ON Model.MonitorModelID = MonitorModel.MonitorModelID LEFT OUTER JOIN

PCModel ON Model.PCModelID = PCModel.PCModelID LEFT OUTER JOIN

PrinterModel ON Model.PrinterModelID = PrinterModel.PrinterModelID

This outputs:-

Asset number     FullName     Model     Expr1     Expr2

00000                User Name   Model     NULL      NULL

00001                User Name   NULL      Model     NULL

00002                User Name   NULL      NULL      Model

However what i hope to acheive is output Model, Expr1, Expr2 into one column like so:-

Asset number     FullName     Model

00000                User Name   Model

Can i do this in the SQL or do i have to do it in my ASP.NET (VB) Page?

Using VSWD 2005 Ex Edition and SQL Server 2005 Ex Edition

Thank you for your replies