Mike,

I just stumbled upon this thread, as I'm just now finally getting around to converting my DB's to MSSQL. On the one message you said:

From researching the forum and internet, I have come to determine that the Collate setting best for VDF/DF
is SQL_Latin1_General_CP1_CI_AS

But then in a later messageto Vicki, you said:
I found that SQL_Latin1_General_CP1_CS_AS matches how the embedded sorting works.

So now, I'm totally unsure which one to pick, when newly converting a database. All of my indexes are Uppercased, but I do have some dashes in those fields, and use looping extensively for updating.

I'm still on VDF 16 with CK 6.0.0.32.

Thanks,
Leslie