hello !
i have query , in which i am concatinating different fields and making a simple string , the length of string is very large, i want to put line break in it , i dont know to do this , my string is now in this format.

LotNo:12 (prod:abc,Qty:45,rate:56,date:12/7/2012),LotNo:13 (prod:abc,Qty:45,rate:56,date:12/7/2012),LotNo:14 (prod:abc,Qty:45,rate:56,date:12/7/2012)

i want to show like this
LotNo:12 (prod:abc,Qty:45,rate:56,date:12/7/2012)
LotNo:13 (prod:abc,Qty:45,rate:56,date:12/7/2012)
LotNo:14 (prod:abc,Qty:45,rate:56,date:12/7/2012)

i already used char(13) but same result. please help me in this ,

Regards

Have you tried char(10)?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.