MSSQL Syntax

Convert data type http://msdn.microsoft.com/en-us/library/ms187928.aspx
Cast ( expression AS data_type [(length)])  
Convert ( data_type[(length)], expression[, style])

e.g.
select book.title, (cast (book.publishDate as String)) as CastDate from book