Full Text Search

• thulani.moyana

  SSC Eights!

  Points: 869

  More actions

  February 5, 2009 at 7:37 am

  #75406

  How do I search for a pattern in a text column. E.g.

  Col Data : "Some text to search for including code like this 09-453 which can be any two digits followed by - then three digits"

  query example: select col1 from tableName where contains(textCol,'"##-###"')

  How do I construct such a keyword

• GSquared

  SSC Guru

  Points: 260824

  More actions

  February 5, 2009 at 8:03 am

  #938875

  I'm not sure if full text can do that. I know it can be done with a Like comparison, but I'm not sure if it can be done with a full text command.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon