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)
 Inserting a very long description with special characters into a string variable

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-02-26 : 23:11:09
aoc writes "How can I insert a description, which can be very long in length which can contain special character like &, £,$, --, etc into a variable of type string. I keep getting an error saying my insert statement has not been finished properly? As users of my system want to be able to use these character types in their description, I don't want to just read the string in and then remove these special characters from the description the user has just entered.

Any ideas"
   

- Advertisement -