Re: How to add a weight factor to a query?

In article <94m3mo$jlg$1_at_nnrp1.deja.com>,   jethro_harding_at_my-deja.com wrote:
> Hi,
>
> How do I add a weight factor to a query? For example, take the
> following query:
>
> SELECT table.field1, table.field2, table.field3
> FROM table
> WHERE field1 = 'value1'
> AND field2 = value2
> OR field3 = value3
>
> What I would like to do now is give each test a factor of importance.
> So (field1 = 'value1') should be the most important, let's say 60%,
 the
> other two should be of importance for 20% each.
>
> Can anybody help me with this? Thanks very much in advance for your
> time and effort!
>

What do you intend to do with these factors?

---
Pb
My opinions are my own and should not be taken as
representing any other group or entity.


Sent via Deja.com
http://www.deja.com/