>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
See this
http://www.umachandar.com/technical/SQL2000Scripts/Main13.htm for better ideas.
If it's not broken, fix it until it is.
My Blog