Hi,
I posted on another forum. I will try here.
There is a field set up with Enter Key Behavior set to NEW LINE IN FIELD.
When I look at a record in Query Analzer with 4 new lines they all show 1 right after the other with maybe 1 or 2 spaces between them. When I use a stored procedure, you have to hit the right arrow key to view it which is giving mve a problem. My stored procedure is doing an insert into a table and the table then is used as the input to a fixed field length file on a FTP site. The field has muliple occurances for each NEW LINE. Obviously this messes up my fixed field length. If the field is 100 characters, I end up with 400 characters. No good.
I have been trying everything for 2 days. Can't find anything anywhere.
Any guidance would be much appreciated.
By the way before you tell me to set the default back to zero, I can't. The user needs it this way. :-(
Remember when... everything worked and there was a reason for it?
I posted on another forum. I will try here.
There is a field set up with Enter Key Behavior set to NEW LINE IN FIELD.
When I look at a record in Query Analzer with 4 new lines they all show 1 right after the other with maybe 1 or 2 spaces between them. When I use a stored procedure, you have to hit the right arrow key to view it which is giving mve a problem. My stored procedure is doing an insert into a table and the table then is used as the input to a fixed field length file on a FTP site. The field has muliple occurances for each NEW LINE. Obviously this messes up my fixed field length. If the field is 100 characters, I end up with 400 characters. No good.
I have been trying everything for 2 days. Can't find anything anywhere.
Any guidance would be much appreciated.
By the way before you tell me to set the default back to zero, I can't. The user needs it this way. :-(
Remember when... everything worked and there was a reason for it?