Quotes

• SQL33

  SSCrazy

  Points: 2044

  More actions

  October 27, 2008 at 9:54 am

  #75348

  How do I query a field (address) in a table (tblAdd) to return records containing address information which contain "quotes" so I can remove said quotes which should not be in this data ?

  select * from tblAdd where address contains(%'"'%) ?

  Thanks...

• Lowell

  SSC Guru

  Points: 323518

  More actions

  October 27, 2008 at 10:13 am

  #890085

  CONTAINS is really for full text queries; for something like this, just use like:

  select * from tblAdd where address LIKE '%"%'

  UPDATE tblAdd

  address= Replace(address,'",'')

  where address LIKE '%"%'

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

• Greg Snidow

  SSCoach

  Points: 16108

  More actions

  October 27, 2008 at 10:17 am

  #890089

  This will show them to you...

  SELECT

  *

  FROM tblAdd

  WHERE address LIKE '%"%'

  To remove them, look up REPLACE in BOL.

  Greg
  _________________________________________________________________________________________________
  The glass is at one half capacity: nothing more, nothing less.