Free text weirdness...

• mikey_the_scouse

  Valued Member

  Points: 74

  More actions

  October 20, 2004 at 7:29 pm

  #361369

  Hi All,

  I'm having some issues with numbers in a free text query. Essentially the query seems to be ignoring the number in some cases. Here's the background...

  1. I have edited the noise.enu to remove 0,1,2,3,4,5,6,7,8,9

  2. When I run the following query I still get 2 records which DO NOT contain the term requested.

  SELECT AB.AD_ID

  FROM AD_BODY AB INNER JOIN

  CONTAINSTABLE(AD_BODY,*, '"master class 5"') T

  ON AB.AD_BODY_ID = T.

  3. When I run the following query I DO get the extra records removed.

  SELECT AB.AD_ID

  FROM AD_BODY AB INNER JOIN

  CONTAINSTABLE(AD_BODY,*, '"master class 5"') T

  ON AB.AD_BODY_ID = T.

  WHERE (BODY LIKE '%master class 5%' OR BODY LIKE '%master class V%')

  Why does SQL Server return a couple of dud jobs? I have rebuilt catalogs, rechecked the SQL, etc but with no luck. Any ideas?

  Also, what is the relation between "5", "V" and "five"???

  Thanks,

  Millsy

• mikey_the_scouse

  Valued Member

  Points: 74

  More actions

  October 20, 2004 at 9:49 pm

  #527391

  Doh!

  The problem is that being an Aussie we use a different locale to the standard install. We edited the noise.eng file and all is sweet....