Conditional Criteria Search

I have a form which uses Get to post fields to another page
which list real esate results.



the form works fine it searches

Area

Property Type:

Min Price: etc by pasing the form fields where I have an sql
query that processes the results.



The client wants to add an extra filed for searching a
reference number field in the smae form which if entered will mean
the search only returns the reference number and nothing else.



How do I do this in DW



this is my exsisting sql code for the search of the existing
fileds



SELECT *

FROM Proeprt

WHERE Price BETWEEN Varmax AND VarMin AND Areaname LIKE
Varareasort AND types.PropertyType LIKE VarTypes AND Bedrooms LIKE
VarBeds



Regards

Andrew Newton