Paul van Brenk.com - Case sensitive search in sql server 2000

Tuesday, August 23, 2005

Case sensitive search in sql server 2000

The easiest way on sql server 2000 is to change the collation on the column you want to do the search on:

ALTER TABLE dbo.Customers ALTER COLUMN CustID char(8) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL

Tuesday, August 23, 2005 6:32:39 PM (W. Europe Daylight Time, UTC+02:00)

Comments [1] - Trackback
Codesnippet | SQL

Monday, October 24, 2005 9:09:58 AM (W. Europe Daylight Time, UTC+02:00)

my status column was 1 char
i had problems where the case was 'a' and i needed 'A'
a third party app was case sensitive but the database collation was not
here is the sql

SELECT * FROM name
WHERE
CONVERT( varbinary(1), status) = CONVERT( varbinary( 1), 'a') AND status='a'
order by last_updated desc

anon

Comments are closed.