>>Another good one is that sql server can be case-sensitive or case-insensitive, depending on the collation sequence you use. sql 6.5 and earlier, you had to set this at the server level at install; you need a different sequence, you needed to reinstall. I don't remember how sql 7 did this (went quickly to sql2k). sql2k allows you to set it at the column level, and change it whenever.
>
>VFP allows different collation sequences, too.
>
>Hilmar.
True. At the index level - or, that is, an index will use the current set collate setting when it is created.
(like I said it was a brief brain dump < g >)
The main point I was making here was that in SQL Server the default sequence affects table and column names as well as data.
Insanity: Doing the same thing over and over and expecting different results.