How to add a weight factor to a query?

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!

Jethro Harding

Sent via Deja.com
http://www.deja.com/ Received on Wed Jan 24 2001 - 02:28:12 CST