SQL Server 2000:Invalid operator for data type. Operator equals add, type equals ntext.

Question

I've got some code that runs all lovely on SQL Server 2008, however I'm forced to try it on SQL Server 2000 server, where it falls down.

Basically I'm looking to combine two columns, with a comma in-between.

SELECT COALESCE(cardesc1, '') + ', ' + COALESCE(cardesc2, '') AS "Car Summary" FROM macros;

Answer 1

Solved it!

SELECT COALESCE(cardesc1, '') + ', ' + COALESCE(convert(varchar(100),cardesc2), '') AS "Car Summary" FROM macros;