Hi Simon,

I'm pretty new to SQL Server myself but we have had several problems with installing our application against our clients SQL Server. Basically, lots of them have different collation settings which our app tends not to like very much. I'm not really sure if there is a standard collation.

To alter the collation of a field through query analyser you can:

ALTER TABLE ja
ALTER COLUMN ja_dept varchar(20) COLLATE Latin1_General_CI_AS

To be honest we try to keep the collation setting at a database level and not to get to low level with it. This is only our way of doing it.

I would be interested in finding out if and why you (not you specifically but anyone) would need to have collation settings different at a field level.

Its all a learning curve to me.

Jon