Case Sensitive if-then

[celauritz]

I have a table where the "Address" field can be typed in either uppercase or lowercase or a mixture of the two. Thus, we mail information to people at for instance:

3021 TaylOR DRive

I thought I could write a formula called UAddress:

uppercase(Address)

And then another formula called Match:

if @UAddress = Address then "OK" else
"Error"

and then just scan for the errors, but they all come back as "OK". Is there a way to make this work?

 

[lbass]

Go into file->report options and uncheck "Database server is case insensitive."

-LB

 

[celauritz]

Well, that was easy.

Thx.