FTS Near Operator

• Tee Time

  Hall of Fame

  Points: 3745

  More actions

  July 26, 2013 at 7:12 am

  #1636139

  Thanks Steve, nice one!

• PChiragS

  SSCarpal Tunnel

  Points: 4965

  More actions

  July 26, 2013 at 7:06 pm

  #1636377

  very good question..

  Thanks Steve..

• sqlnaive

  SSCoach

  Points: 17437

  More actions

  August 6, 2013 at 1:27 am

  #1638812

  Wonderful question. I have never worked on FTS. So in order to get the correct answer, I had to dig MS technet site and bingo. learned something new.

• aochss

  SSCommitted

  Points: 1677

  More actions

  August 6, 2013 at 1:27 pm

  #1639089

  Very good question...We use FREETEXTTABLE instead of CONTAINSTABLE in our FTS table searches. Thought for sure that the 3 was characters and not words apart.

  I always learn more when I get it wrong.

  Anton

• Miles Neale

  SSChampion

  Points: 13147

  More actions

  August 8, 2013 at 5:41 pm

  #1640025

  Koen Verbeeck (7/25/2013)

  ---

  Great question. Never use full text search though, so definately learned something.

  +1

  Not all gray hairs are Dinosaurs!

• jfgoude

  SSCrazy

  Points: 2586

  More actions

  September 13, 2013 at 6:55 am

  #1650037

  easy one thank's

  the answer was THE only logical one

• Hany Helmy

  SSChampion

  Points: 13921

  More actions

  October 2, 2013 at 12:54 am

  #1655126

  Got it wrong :hehe:, but no problem; definitely learnt something new.

  Thanks & Best Regards,
  Hany Helmy
  SQL Server Database Consultant