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.
| Author |
Topic |
|
valedaw2
Yak Posting Veteran
50 Posts |
 Posted - 2009-06-30 : 09:13:01
|
| Hello,I have a file with double apostrophes in the data. For example - Ronald"s. How can I replace these with single quotes in SQL 2005? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-06-30 : 09:14:15
|
[code]replace(col, '"', '''')[/code]
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
valedaw2
Yak Posting Veteran
50 Posts |
Posted - 2009-06-30 : 09:21:31
|
| I checked the data and it is actually 2 single quotes - PATRICK O''CONNOR |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-06-30 : 09:25:32
|
oh sorryreplace(col, '''''', '''')
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
valedaw2
Yak Posting Veteran
50 Posts |
Posted - 2009-06-30 : 09:26:50
|
| I did get it to work with replace(clean_name1, '''''', '''')Thanks |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Double apostrophes in data