0

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

2
Contributors
1
Reply
2
Views
5 Years
Discussion Span
Last Post by scudzilla
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.