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 |
eugz
Posting Yak Master
210 Posts |
Posted - 2014-06-17 : 16:21:50
|
Hi All.I imported data from flat file to SQL Server database table. After execution one of column got data with double quotes. It look like:22222.....02/14/2014....."Smith, John" 333........02/14/2014....."Brownies, Alian"How to remove quotes?Thanks. |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-06-17 : 16:34:10
|
If double quotes don't exist in the middle of the data, then you can use this:update yourtableset yourcolumn = replace(yourcolumn, '"', '')Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
eugz
Posting Yak Master
210 Posts |
Posted - 2014-06-17 : 17:06:16
|
Works great, Thank you Tara. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-06-17 : 17:12:07
|
You're welcome, glad to help.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|