SQL - Return Carrage

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 1

SSC Guru

Points: 51650

October 29, 2002 at 9:58 am

What about field1 + char(10) + field2 ?

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 2

Or chr(13). I use Allen's suggestion. If you need the normal DOS end of line, use mine.

Steve Jones

Maqbool Grasshopper Points: 17 More actions · Answer 3

Thanks chaps for an instant result. Problem solved

Simon Sabin SSCrazy Eights Points: 8142 More actions · Answer 4

Or both for a carriage return line feed (needed for notepad in NT)

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

lambje SSCrazy Points: 2085 More actions · Answer 5

simonsabin is correct. You should always use both characters.

IsNull(field1, '') + char(13) + char(10) + IsNull(field2, '').

I also tend to include an IsNull to ensure I get field1 or field2 if either one is null.