Changing collation on the fly - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Changing collation on the fly

Author

Topic

Amethystium
Aged Yak Warrior

701 Posts

Posted - 2004-06-01 : 11:24:33

Greetings!

I am pretty sure that you can change the collation of a column in a WHERE clause but the following line gives me an error,


collate(dep.membno, 'SQL_Latin1_General_CP1_CI_AS') = ee.employeereference

Still can't find it in BOL, but I have seen it somewhere in there beofre.

_________________________________________________________
The cradle of civilisation will defeat the new monsters of the world.

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2004-06-01 : 11:47:54

The examples in BOL are:-


SELECT (CASE WHEN id > 10 THEN GreekCol ELSE LatinCol END) COLLATE Latin1_General_CI_AS 
FROM TestTab

SELECT * 
FROM TestTab 
WHERE GreekCol = LatinCol COLLATE greek_ci_as

look for collations and then the sub-category of COLLATE...

Amethystium
Aged Yak Warrior

701 Posts

Posted - 2004-06-01 : 11:56:24

Played.

_________________________________________________________
The cradle of civilisation will defeat the new monsters of the world.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources