search and replace possible on SQL?

Hi all

i have two areas where i get information for my project. one is obtained
from a SNMP walk across our systems and the other is captured by support
personal.

Now i want to be able to compare a list of systems that the SMNP walk has
handed over to me with the information that has been data captured by the
support personal and either update or insert.

this would be easy if i could just get the support personal to enter the
information as it appears in the DNS (they add spaces to make it easier to
read.), after many hours of head banging i have given this up. I also can't
just take out the spaces they put in to the data as there are some devices
(like hubs) that have names with spaces in them.

is there any way of doing this with sql eg.

select * from table1 where name.table1 = <regualer(name)>.table2;