Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Problem with TEXT Data Type truncating the blanks at the end of the data stream

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-05-18 : 08:35:51
Ramesh writes "Is there any way to have the TEXT Data Type NOT truncate the blanks at the end of the data stream that is inserted into the field?

For example, when I insert 'abc ' into a TEXT Data Type field and when I read it, I am only getting 'abc'. But, I would like to read it as 'abc ', the way I inserted it into the table.

Thanks for your help.

Ramesh"
   

- Advertisement -