in access 200 i had a form bound to a query and the sql statment for it is:-
SELECT houses.id, houses.address1, houses.address2, houses.town, houses.county
FROM houses
WHERE (((houses.[post code])=[Forms]![find house]![post code])) OR (((houses.id)=[Forms]![find house]![post code]));
but when i up size this to sql server 2000 it will not up size this query so could some one tell me what is the correct statment for this query in a sql database view or stored procedure
SELECT houses.id, houses.address1, houses.address2, houses.town, houses.county
FROM houses
WHERE (((houses.[post code])=[Forms]![find house]![post code])) OR (((houses.id)=[Forms]![find house]![post code]));
but when i up size this to sql server 2000 it will not up size this query so could some one tell me what is the correct statment for this query in a sql database view or stored procedure