Heh. Well, you need to do your fair share of testing also.

After all, it's your data =;o)

Especially look out for 'weird' chars (from an ascii point of view) that may not convert as expected.

It all depends on if you do have extended ascii, from which collation to which collation you're going etc.

Here's a small illustration of what may be an issue.. (or it may not)

[font="Courier New"]

select'Ø' collate SQL_Latin1_General_Cp1_CI_AS, ascii('Ø' collate SQL_Latin1_General_Cp1_CI_AS)

select'Ø' collate SQL_Latin1_General_Cp437_CI_AS, ascii('Ø' collate SQL_Latin1_General_Cp437_CI_AS)

---- -----------

Ø 216

(1 row(s) affected)

---- -----------

O 79

(1 row(s) affected)

[/font]

/Kenneth