update line feed character in a varchar field

See more:

SQL-Server-2005

SQL-Server

Hi all,

I am using Sql Server 2005.
I have a varchar field in a table in which I want to insert some text with line feed using sql Insert statement.
The result is updated but it shows a space where ever I try to insert the line feed character char(13).

Below is the sample code that I am trying for R&D:

create table #tab1
(
a varchar(10)
)
Insert Into #tab1
select 'a' + char(13) + 'b';

select * from #tab1
drop table #tab1

Though it looks fine when I view the results in Text but in Grid results it shows a space.

Does anybody have a solution to this?

Thanks in advance,

Gopal