select values from two columns and display as one column
===

I have a table with two columns  [Date], [StopName],  i want to write a query which will show both columns as one column  like e.g.  12/05/2007: Stop1. So far i was trying like this

    SELECT  Date + ':' + StopName as Departure from tbldept.

Any suggestion?