I am now officially an idiot. The datacolumn is correct in being NVarchar(MAX) BUT I overlooked the fact that my stored procedure was accepting the data as only Varchar(MAX), doh!!!...

I still current have everything set to the database default, which is as follows;

Windows Collation - Latin1_General

Dictionary Sort - Accent Sensitive.

This is working fine for most of main languages as...

Tried this Dave but still no joy. Any other ideas? I need to make a connection to SQL2K so that I can convert the database to SQL2K5.

Thanks for your reply David but I have already done that. When I try to register and browse for the SQL2000 server it appears OK under the list of network servers, I...

Thanks Paul, at last I can now take a break!

Thanks for your help guy's, got it sorted.

Just one additional question, I am updating a number of other columns at the same time and I am looking at some additional conditional processing, i.e. I only need to...

Thanks for your reply, I was hoping that there was some method whereby one character set cross-referenced another i.e. 'n' & 'ñ' would be interpretted as the same, wishful thinking...

Many thanks guy's. With your help you have saved my sanity. Problem solved.

Thank you all for your quick replies, you have all been very helpful.

Thanks evorsten, these links are very helpful. Just a side note, I have been looking into the collation settings of my SQL installation and notice that there is an option...

Thanks for all of the replies.

Does anyone know of any other method, Soundex appears to be a little too vague for the level of accuracy that I require.