See http://www.iconv.com - an online site with conversion stuff. May be ok if you have a one time need.

Yes - the computer name of the who .. is the correct response. The issue is exactly as noted, it depends where the query is executed. That unit's name will...

Cool - as I said, I found it elsewhere and used it pretty much as it was. Thanks for the update.

Don't remember exactly where I found this, or I would attribute to the original author.

Have used it in a couple of cases to remove dups where there was at...

See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ia-iz_3iex.asp