& is displayed as amp in sql server 2008 R2

[rahul2310]

I am new to sql server
I have web application in asp.net 4.0 with code in vb.net

I am saving data for example: hr & safety

When i save data in sql server 2008 R2 and retrive it in my web
forms it shows hr amp safety

what is it? how can i solve it? and what if i want to replace & with simple and?

Please Help

Is there any query to solve it
Because there are 40,000 records with &

I am fine with using simple and or simple dash instead of &

[ck9663]

You can use dash or you can replace the "&" with "&" before you display the string.

Good Luck!!!


~~ CK