Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

case sensitive select

2 views
Skip to first unread message

Reto Loser

unread,
Jul 15, 1998, 3:00:00 AM7/15/98
to
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

unread,
Jul 15, 1998, 3:00:00 AM7/15/98
to
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

unread,
Jul 17, 1998, 3:00:00 AM7/17/98
to
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

unread,
Jul 20, 1998, 3:00:00 AM7/20/98
to
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

0 new messages