Sort order defines all E-like characters as equal

[swolly]

Hey,

I want a search of name ='Jose' to find both Jose and José, but with

SELECT * FROM Users WHERE name LIKE '%Jose%'

i only get Jose, in "Inside SQL SQL" an article shows this:

If you want a search of name ='Jose' to find both Jose and José, you should choose accent insensitivity. Such a sort order defines all E-like characters as equal:

E=e=è=É=é=ê=ë

but how shut i do this ???

MSSQL 2000 SP 4
Server Collation: Latin1_General_CI_AS

Windows 2003 Server Standard

Thanks for Help !!!

[swolly]

Hey,

I want a search of name ='Jose' to find both Jose and José, but with

SELECT * FROM Users WHERE name LIKE '%Jose%'

i only get Jose, in "Inside SQL SQL" an article shows this:

If you want a search of name ='Jose' to find both Jose and José, you should choose accent insensitivity. Such a sort order defines all E-like characters as equal:

E=e=è=É=é=ê=ë

but how shut i do this ???

MSSQL 2000 SP 4
Server Collation: Latin1_General_CI_AS

Windows 2003 Server Standard

Thanks for Help !!!

Change collation

i only must chane the collation to Latin1_General_CI_AI (CaseInsensitive AccentInsensitive), but i only find now o=ö=ò... but if i search in german like möller i found moller, móller... but in englisch möller will be written like moeller, is ther any way to change or edit collation to find

ö=oe...

Thanks a lot :o