Help !!

I have a table with 2 fields holding phone numbers 'Home' and 'Mobile' over the years these have been populated with no standardisation on format, so I have

++33 0562346789
33 (0)562346789

you get the picture

Now I need to be able to search by phone number (or part phone number) so I need to strip out all non numerical characters so I can perform a LIKE with the inputed string. Can I do this on the fly within the query ?