Records with a double quote in them

• dwjongbloed

  SSC Eights!

  Points: 943

  More actions

  August 31, 2010 at 1:26 pm

  #103977

  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 stuck

  select *

  from dbo.document

  where substring(var_fld_4,6,1) =

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736162

  More actions

  August 31, 2010 at 1:34 pm

  #1214585

  Don't use substring.

  Use charindex and look for a charindex() > 0

  http://msdn.microsoft.com/en-us/library/ms186323%28v=SQL.100%29.aspx