I'm not sure I'm following you.  Do you still need help with this problem??

If you do, where did you put the password and how did you try to import the...

Can you post the code you are using to arrive at those hex values so we both talk the same langage.

I'm gonna say the old adage :

If it ain't broke, don't fix it.

But I'm also gonna ask where do you remove the password from?

SELECT REPLACE('Microsoft™',char(153),'')

works fine for me.

May I ask why you are bothering with the HEX translation??

Are you sure you are getting the ascii code for the right T then??  I don't see any other valid explaination.

Maybe the text source was a word document and that the text was formatted that way... or any other variations on the same theory.

What is the ascii code of the...

Sure can, the search engines don't care about the post date .

Good points.  But the DBA coming to me wondering how to get the min value between 11 columns is going to go back to school and learn to design databases...

I'm curious, have you tried this with 1M rows in the table and let's say anywhere between 2 and 5 columns?

Can you tell us the rest of the tasks, that way we code only once .

What do you mean by just this record?

Thanks for letting us know .

A left join or exists query doesn't take that much time.  It may take a few seconds but surely not long assuming you are using the right indexing strategy.

Also before doing...

Sorry but I don't have time to troubleshoot this one for you... I hope Steve can spare a few minutes for this one...

You must put your image on a web server, or else only you, from you pc will be able to see it.