case-sensative query

case-sensative query

Post by Chadwick DeVos » Tue, 29 Feb 2000 04:00:00



What is the best way to create a case sensative query?  The "like"
statement is not doing it.
 
 
 

case-sensative query

Post by Roy Harve » Fri, 03 Mar 2000 04:00:00


Chadwick,

Quote:>What is the best way to create a case sensative query?  The "like"
>statement is not doing it.

If your database is defined as case-insensitive (controlled at install
time by the SORT ORDER chosen, and only changeable by a re-install)
then LIKE will not be case sensitive.  Neither will < > or =.

The only way I know of to perform a case sensitive test in a
case-insensitive database is to do it character by character using the
ASCII function.

Roy