On 11 Oct 2006 11:46:10 -0700, "Robert M. Gary" wrote:


Ron Rosenfeld wrote:

Usually that space is CHAR(160) and can be removed using the SUBSTITUTE
function.

Your right. After doing a find replace for 0160 replace with "", it
worked. I can't believe Microsoft hasn't addressed this with =clean()
yet. Isnt' think was =clean is for?

-Robert

I would have thought so.

Glad it worked.
--ron