>>It is not clear why you included a COLLATE clause in an ALTER DOMAIN

>>statement. You can't change the COLLATE property of a domain, which
>>is why you got the error: COLLATE is not expected in an ALTER DOMAIN
>>statement. But you were not trying to change that, anyway.

>>HB

The question is why i can not do this?

I need to change collation to perform order and UPPER without need to include COLLATE in it

regards,

Karol Bieniaszewski