Re: AND query on multivalue text

2008-11-24 Thread Antonio Zippo
>On Nov 24, 2008, at 8:52 AM, Erik Hatcher wrote: > > On Nov 24, 2008, at 8:37 AM, David Santamauro wrote: i need to search something as myText:billion AND guarantee i need to be extracted only the record where the words exists in the same value (in this case only th

Re: AND query on multivalue text

2008-11-24 Thread David Santamauro
On Nov 24, 2008, at 8:52 AM, Erik Hatcher wrote: On Nov 24, 2008, at 8:37 AM, David Santamauro wrote: i need to search something as myText:billion AND guarantee i need to be extracted only the record where the words exists in the same value (in this case only the first record) because in

Re: AND query on multivalue text

2008-11-24 Thread Erik Hatcher
On Nov 24, 2008, at 8:37 AM, David Santamauro wrote: i need to search something as myText:billion AND guarantee i need to be extracted only the record where the words exists in the same value (in this case only the first record) because in the 2nd record the two words are in different value

Re: AND query on multivalue text

2008-11-24 Thread David Santamauro
Hello all, I'm new to the list but want to say great work! ... see comment below On Nov 24, 2008, at 7:59 AM, Erik Hatcher wrote: On Nov 24, 2008, at 6:12 AM, Antonio Zippo wrote: is it possible to have and AND query on a multivalue text? i need to search something as myText:billion AND

Re: AND query on multivalue text

2008-11-24 Thread Erik Hatcher
On Nov 24, 2008, at 6:12 AM, Antonio Zippo wrote: is it possible to have and AND query on a multivalue text? i need to extract the record only if the words are contained inside the same value for example 1st record: The U.S. government has announced a massive rescue package for Citigrou

AND query on multivalue text

2008-11-24 Thread Antonio Zippo
hi all, is it possible to have and AND query on a multivalue text? i need to extract the record only if the words are contained inside the same value for example 1st record: The U.S. government has announced a massive rescue package for Citigroup, saying it would guarantee more than $300 bi