select name, address, city, phone1 , replace(fax,'-','') as fax from pharmacyInfo ph where (ph.name like "%{search}%" or ph.address like "%{search}%" or ph.phone1 like "%{search}%" or ph.fax like "%{search}%") AND ph.address like "%{searchaddress}%" AND ph.city like "%{searchcity}%"