How/what query are you using to search? It may be that the collations are different. You can find the collation of the column and collation of your database using the following:-- column
SELECT Collation_name FROM INFORMATION_SCHEMA.[COLUMNS]
WHERE TABLE_NAME = 'YourTableName' AND COLUMN_NAME = 'YourColumnName';
-- database
SELECT DATABASEPROPERTYEX('YourDataseName', 'Collation')If they are different, post the query you are using and people on the forum should be able to suggest how to force the collations to match.
Sql server language support
Posted - 12/06/2012 : 05:01:40
