ok, I am a bit stumped.  True, the collation of the columns in UnitConversion are swedish, but in my tmp table, there is no collation...so why a conflict??  Can I...

Off to do some reading!!  Thanks again Luke, for all your help!

Thanks Luke!  This looks like it should work.  I am fussing with it due to an error that says :  Server: Msg 446, Level 16, State 9, Line 197

Cannot resolve...

oops, that where clause should read:

where

 UserWeightUnit <> 'kg'

thank you again!

Here ya go...show me da magic!!

update t

 select @UserWeightFactor = Factor

 from UnitConversion

 where FromUnit = 'kg'

 and ToUnit = UserWeightUnit

set UserWeightFactor = @UserWeightFactor

from

 @tmp t

where

 UserWeightUnit <> 'cm'

don't leave me just yet!!!  I am working on another update....brb!! 

Thanks a ton Luke!!  It worked beautifully!  Funny, after seeing it this way, it totally makes more sense!  Thanks again!!

Thanks Kathi, I appreciate the input.  Off to play with a test db!! 

ok, I read all of this stuff.  This is indeed my issue.  SP4 is not an option at this point, so the first read won't work.  If I run the...

Thank you Martin...off to read!!

Thanks Kory...headed there now!

Wahoo!!  it works!  Thank you so much!  Thanks for the lesson as well.  I love this stuff!

Thank you Jane, I will go do some investigating!!

ok, I deleted out one of the (not working) linked servers.  I tried to recreate a new one and got this error:

Error 18452:Login failed for user '(null)'.  Reason: not associated...

Thank you!!  I am on it!!