case sensitive select

[Reto Loser‏]

Hello, I would like to ask, if it's possible to do a select to catch rows
who have lower characters. I just walked trough the help and could not find
any help or settings to do so. Is there a possibility or do I have to use
the ASCI function ??

Thanks in advance
Reto Loser

[Dan Guzman‏]

Compares will be sensitive if a case-sensitive sort order was chosen during
SQL Server installation.

Hope this helps.

Reto Loser wrote in message <6ohi9d$4...@gd2inews.swissptt.ch>...

[Reto Loser‏]

Thanks for your help!!
Somtimes it's realy hard to get used to SQL-Server. I realy miss some things
I think should bi build in ... like functions or stuff like that, where you
may can develop enhanced functionality.

Regards Reto

Dan Guzman wrote in message <6oi585$o2f$1...@camel25.mindspring.com>...

[Neil Pike‏]

Reto,

I assume your database is case-insensitive? If so then you could try
converting the field to binary and comparing it to UPPER(field) also
converted to binary. This would show the presence of any lowercase
characters.

Neil Pike MVP/MCSE
Protech Computing Ltd