browse keys (@bk)

[Jay R. Ashworth]

On Tue, Jul 20, 2004 at 08:45:13PM -0400, John Esak wrote:
> want case insensitivity to be the default and not otherwise. The _vast_
> majority of people out there type in "smi" at an index key prompt in IUA and
> they would be _very_ upset if they weren't brought to the first "SMITH"
> record should one exist.

If you can build an index on a '*' column populated by all upper case
data, type 'smi' into it, and get anywhere, you let me know, John.

What you *actually* mean here is building an index on a column that the
programmer *consciously* forced to uppercase, which, as Mark correctly
noted, is a completely different thing.

Cheers,
-- jra
-- 
Jay R. Ashworth                                                jra at baylink.com
Designer                          Baylink                             RFC 2100
Ashworth & Associates        The Things I Think                        '87 e24
St Petersburg FL USA      http://baylink.pitas.com             +1 727 647 1274

	"You know: I'm a fan of photosynthesis as much as the next guy,
	but if God merely wanted us to smell the flowers, he wouldn't 
	have invented a 3GHz microprocessor and a 3D graphics board."
					-- Luke Girardi