SQL no case

[Ruslan Zasukhin]

On 28/2/07 12:31 AM, "Scott Runkel" <srunkel at hypix.com> wrote:

Hi Scott,

> In v1 there was an SQL key word "NO_CASE" or something like that. I can't find
> the equivalent for v2, to ignore case in SELECT searches.

There is no such equivalent

Instead you should use

    db.CollationAttribute( kStrength ) = kPrimary  (kSecondary)

Then the whole db will be in case-insensitive state.

You can specify this parameter for Table or field also.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]