How can I change the collation of an existing view?
Is there a way to change the collation of a view?
ASKER
This appears to alter the collation for the field [name]. I'm trying to change the collation for the entire view.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
AS
SELECT ProductID, Name FROM Production.Product
GO
ALTER VIEW GetProducts
AS
SELECT ProductID, Name COLLATE Modern_Spanish_CS_AS FROM Production.Product