text from sql server to be printed in new lines.

retrieved data from TEXT field of sql server to be posted in new lines.

[shahchirag1]

I m using sql server7 for one vb application. I m populating a table with one TEXT field. Data comes from text file where I read all data line by line.

After insertion, I need to get back the data and put it in same format (line by line, no other formats needed.). I can't add "end characters" after each line which may result in increase in length of characters. "vbcrlf" isn't working.

Hence a way to display string in new line will be helpful.

[f00sion]

When you add the data line by line to the database do you append a vbcrlf at the end? If that still doesn't work the only other way would be to add a special character at the end of each line and then splitting it later when you read the data.