Danian

Hi All, Hope you can help, i have a MySQL string that i want to remove all the spaces in name and postcodes and then uppercase them, before I try to match them in the Database, but spent a couple of hours and tried various ways, but still failing. Please can yo have a look and advise.... SELECT * FROM vwproperty WHERE str_replace(' ', '', strtoupper(surname)) LIKE '% ."strtoupper(str_replace(" ", "", {$_SESSION["Surname"]}))."%' AND str_replace(' ', '', strtoupper(postcode)) LIKE '% ."strtoupper(str_replace(" ", "", {$_SESSION["Postcode"]}))."%'ORDER BY surname Thanks in Advance, D