ignoring of spaces

[g7pwx]

Hi can anyone tell me how to ingnore a space in a row

here is the code i use to call it

{
	$query="SELECT * FROM company_details WHERE";

if ($phone!="")
{
	$query.=" phone LIKE '%$phone%'";
		}

there are phone numbers in that row called phone and are ordered like 155 2323 and some are like 4342232 is there anyway to get it to ignore the space and search wether they put 227 2273 or 2837465 ?

thanks

[Lars_Berg]

$query.=" replace(phone,' ','') LIKE replace('%" . $phone . "%',' ','')";

[g7pwx]

Thanks loads that worked great.