I forgot to mention I'm using SQL 7.0, not 2000 yet, if that makes
a difference. Also, I've found a vague mention or two about case sensitivity in SQL Books Online, but nothing specific yet about the install settings.



>Thank you very much Sergey.
>
>I'll be looking now in the books I have for instructions on how to change the case sensitivity during install, but if you'd tell me, I'd appreciate it.
>
>
>
>
>
>>The SQL Server can be installed as case-sensitive or not (Default). In the second case any character comparisons would be case-insesitive. You can make them case sensitive by converting string values to a binary format

SELECT * FROM history
>>WHERE CAST(type AS binary(1)) IN ( CAST('L' AS binary(1)))
>>

>>
>>>Hi,
>>>
>>> SELECT * FROM history WHERE type IN ('L')
>>>
>>>seems to ignore case, because I'm getting all
>>>records with both upper and lower case L's.
>>>
>>>Is there anyway to trap out the lower case L's?
>>>
>>>Thanks,
>>>
>>>Tom
>>>
>>>PS I tried to search for 'IN keyword', but the search
>>>function says I have to have three characters minimum.