Performing A Whitespace-insensitive Query

Hi,

I am trying to concoct a query that will join rows on the basis of a
whitespace insensitive comparison. For instance if one row has the value
'a<space>b' and another has the value 'a<space><space>b' I want them to be
considered equal (but not the same as 'ab')

I am happy to do some T-SQL if that helps. Also I have a full-text index on
the column in question, but note that I am comparing rows against each
other, not to a fixed string.

This is for a one-off job, so if there is no obvious way to do it on the
database, I will just bcp out the data and knock up some perl or something
to do it. All other things being equal I would rather do it on the database
though.

Many thanks

Andy