query

[mohantfor net]

i want insert like this text.mohan's.how can i insert this in sqlserver.plz send me.its urgent

[gauthee]

use 'mohan'''s' and insert the value just play with apostrophee until the entire value becomes a single string!

Gautham

[mohantfor net]

thank u .but how can i concate in asp.net for insert

[Krish KP]

refer to message below with subject "Problem with special characters in SqlParameter" similary usage is explained as what you are looking for, in different ways ...

Regards KP

[Blue_Boy]

if you are using asp.net with C# then try TextBox1.Text.Replace("'","''");

---

I Love SQL