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 |
|
dwjongbloed
Starting Member
9 Posts |
 Posted - 2010-08-31 : 15:17:51
|
| I have a bunch of records that have a " in a given column and I want to select those records out. Actually in the long run I am going to want to replace that " with a blank but for now I just want to get a record count. What is the correct syntax that a person should use for this? If you'd be willing to give the syntax for updating it as well I'd appreciate it.here's what I have and where I'm stuckselect * from dbo.documentwhere substring(var_fld_4,6,1) = |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-08-31 : 15:37:20
|
Are you sure it is always at position 6,1?Anyway.= '"'(one_single_quote your_double_quote one_single_quote)
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
Finding records that have a double quote in column