NPM and search results

skalyanaraman · Post by **skalyanaraman** » Tue Jun 17, 2003 4:46 pm

Hi,
We are trying to run query on a field, say TITLE like so,

select DOCID from tbldoc where TITLE like '#<=3'

We get lots of hits and bunch of the docs had the words "several" and "a %" and "a decis" (the last one is actually highlighed off of "a decision") and other stuff.

Why is this so? Can we avoid these and just force it to stick to numbers?

Thanks in advance for the help!

Post by **mark** » Tue Jun 17, 2003 5:53 pm

NPM always looks for spelled quantities as well as plain numerics. It's also not limited to whole numbers. "several" is anything from 3 to 10, "a %" is .01, "a deci*" is .1.

If there's structured numeric data it should be placed into integer field(s).

skalyanaraman · Post by **skalyanaraman** » Tue Jun 17, 2003 5:57 pm

Thanks for the reply. But I am curious,
1. Several is 3-10 in the Texis world right? Is this kind of hard-wired or configurable?
2. how is a deci = .1?

We will take your suggestion for storing in numerical fields!! thanks

Post by **mark** » Tue Jun 17, 2003 10:01 pm

1. hardwired
2. "a"="one", "deci"=tenth