Loading a data field that is sometimes all upper-case, sometimes not?

[#1]

Hello. I have some data that has a Region and Market field. The problem is, sometimes it will be in all caps, and sometimes not. QlikView considers this a whole different thing.

So when I make a listbox just to show my Regions, I get:

MIDWEST

Midwest

NORTHEAST

Northeast

SOUTHEAST

Southeast

...and so on.

I want QV to consider MIDWEST the same as Midwest.

Any help please? Thank you.

[swuehl]

Try

LOAD

...

capitalize( REGIONFIELD) as REGIONFIELD,

...

[#3]

Sorry right after I posted my question I found a reasonable answer elsewhere (I swear I searched first but I wasn't entering the appropriate keywords the first time around).

Someone else suggested FORCE CASE UPPER before I load the field in question.

I am trying that now and it SEEMS to be working OK.

Thanks!