Hi,
In DMX, I have following SQL Quary in result page,

SELECT Region, Type, Bedrooms, Price_Range, Title, Features, Short_Description, Property_ID, Imain
FROM DRE_Sales
WHERE Region LIKE '%MMColParam1%' AND Type LIKE '%MMColParam2%' AND Price_Range LIKE '%MMColParam3%' AND Bedrooms LIKE '%MMColParam4%' AND Postcode LIKE '%MMColParam5%'
ORDER BY GBP

With this quary, I can find the result of Region, Type, Price_Range But no selection with Bedrooms, can't filter the bedrooms.

And also no result come from Postcode, except if I choose full post code.

I wanted to see that if any one choose region + half post code it should show me a result.

Or, combination of Region + Type
Or combination of 4 List/Menu
Or Just only the Post code

Please, any friend advice me how should be the Quary???

Thanks

Babu