nullify an index - incorrect use of operators

I've heard that you can nullify an index if you use operators "incorrectly", such as in the following statement:

sales.amount => 40000

In other words, in order to prevent nullifying the index on the sales table, the operators should look like this:

sales.amount >= 40000

Is this true?

Thanks in advance ... please remove the 'nospam' from the return address ( dmorse_at_iquest.net or dmorse_at_cinergy.com )

Dave Morse
Consultant - InfoTech Consulting, Inc.

"If at first you don't succeed, then skydiving isn't for you." Received on Mon Aug 17 1998 - 11:37:54 CDT