CODEWITHSUNDEEP
sql-server-2005-express
user1730668
user1730668

Reputation: 11

HOW To remove ' in a column SQL server 2005

I have a specific column (description) in a particular table. I used bulk loading to insert data in table, but in retrieving data it's giving an error because of this column (description).

The problem is occuring due to ' in description (like 12' height). So how can I remove this ' in that column?

Upvotes: 1

Views: 63

Answers (1)

alistair
alistair

Reputation: 1074

[Is sounds like you are running some kind of script that fails when it tries to insert a value with a single quote in its value, between two quotes in code or dynamic sql. Your problem won't be in the database, it will be where you are processing it. A quick hack would be to run an update replace. In this case I am deleting your empty quotes.

Update [tablename] set [description] = replace([description],char(39),'')
where [description] like '%' + char(39) + '%'

However this is just a hack....your problem is somewhere else where you are retrieving and processing the data

Upvotes: 1

Related Questions