Re: In-case sensitive searches

> You won't like this technique, but it's what we used to get around the
> problem.

You're right, i don't like it ;-)

> We created the table with 2 name columns.

Yes, i came up with that one myself. Darn, why can't we do a CREATE INDEX xxx ON table(UPPER(column)) ... sigh ;-)

Brian

--
------------------------------------------------------------------------
Brian Rasmusson, Software engineer & analyst     e-mail: brianr_at_belle.dk
Belle Systems A/S                                web   : www.belle.dk
Network, Internet and communication specialists  phone : +45 59442500
------------------------------------------------------------------------