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:
but how shut i do this ???
MSSQL 2000 SP 4
Server Collation: Latin1_General_CI_AS
Windows 2003 Server Standard
Thanks for Help !!!