problem in asp

[danasegarane]

Dear Team,
I am retriving data from MS SQL server and showing the same .But the problem is one field is declared as nvarchar .And it contains the some values like <abp> .While retriving i am not able to get these values.Why .

[jvanamali]

it is problem with html

<P><abp></p> doesnot actually display <abp> as it sees abp as a tag
use <p>&lt;abp&gt;</p> to display <abp>

&lt; = <
&gt; = >

[danasegarane]

The same problem is for "This is a test messeage" .While Displaying this it displays the "This" only.It is omiting others.How can I solve this

[jvanamali]

you shouldnot be facing a problem in this case check in the database whether the correct value is inserted and you retrieved complete sentence.

eventhen if you face a problem try replacinf space with &nbsp;(shouldn't be neccessary normally)