>Our SQL SERVER is set for case insensitive. But we need to do the case sensitive selection. For example, we have a field called Letters. In this field, we have 'ABCD', 'AbCd', 'ABCd', 'ABCD','abcd'. We only need select the record having this field ='AbCd'.
>
>How can we write this SQL selection?
>
>Regard
>
>Jim

Answer from another forum: (http://tek-tips.com/viewthread.cfm?qid=1305916)

Select * From @Temp Where Data Collate SQL_Latin1_General_CP1_CS_AS = 'Blue'

Or Re: Case Sensitive comparaison, simple one! Thread #637469 Message #1091060