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
 Transact-SQL (2000)
 update on a column that is full of HTML

Author  Topic 

fclanton
Starting Member

1 Post

Posted - 2007-12-26 : 17:36:38
The discription column of my item table has five and a half pages of html code in it.... I need to update all of the records in this table with a new discription. The top line of what is displayed is different in every record. Need to change it so that every record in the same.

The html code is full of single and double quotes and fails with many errors when i try an update qurey.

Is there someting i can wrap all of that code in to stop sql from giving me an error?

Or

Is there someway that once that column is edited in one record to make all records equal to it?

georgev
Posting Yak Master

122 Posts

Posted - 2007-12-29 : 19:38:30
How do you define the top line?
Give some example data and desired results please!



George
<3Engaged!
Go to Top of Page
   

- Advertisement -