carriage return and line-feeds

Question

• 'DateM (Monday): ' + ISNULL(@Mon,'')+CHAR(13)+CHAR(10)

• 'DateT (Tuesday): ' + ISNULL(@Tues,'')+CHAR(13)+CHAR(10)

RESULTS:

Is not wrapping.

DateM (Monday): Sep 8 2009 12:00AM DateT(Tuesday): Sep 9 2009 12:00AM

I want it to wrap.

DateM (Monday): Sep 8 2009 12:00AM

DateT(Tuesday): Sep 9 2009 12:00AM

Answer 1

This works:

'DateT (Tuesday): ' + ISNULL(CONVERT (VARCHAR(8),@Tues,1),'')+CHAR(13)+CHAR(10)