Check Case in a Case-Insensitive DB
I am looking to check a column in a table for a particular case for its first letter. E.g I want to find where the column is 'Published' and 'published'
The column is varchar(20 and I use SQL 2000.
Thanks in advance.