Issue converting sql concatenate (||) in Oracle sql to Sql Server (transact-sql )

Hi,

I'm trying to do in sql server something that was very easy in Oracle Sql...
select col1||'''|'''||col2||'''|'''||col3||'''|'''||col4....etc from <usertable>

and I'd end up with a string with columns separated by a pipe (|) it would cope fine with dates not needing cast or convert etc...

There doesn't seem to be the equivalent in transact-sql used within sql server.

I appreciate that I have to cast date columns but the implication is that I can use the + operator but when I do so I get the message  "Error converting varchar to numeric" implying it is trying to numerically add them together!!!
(e.g. select cast([timestamp] as varchar)+'|'+[No_]+'|'+ etc.... from <usertable> )

Any ideas what I'm doing wrong?
Thanks
Stephen