Mixed Case Data - Help

[sagobogger]

I'm sure I'm missing something obvious but I need to buy a clue. Someone decided it would be nicer to have some data feeds in mixed case instead of upper case, so before we got e.g. SMITH,JOHN and now we are suddenly getting Smith,John

Previously

WHERE NAME LIKE 'SMITH%' or
WHERE NAME EQ 'SMITH,JOHN'

worked fine but now

WHERE NAME LIKE 'Smith%' or
WHERE NAME EQ 'Smith,John'

are not working. I don't imagine this is an unusual situation so how do we make our reports work again?

WebFocus on a Windows Server.

TIA

 

[sagobogger]

Hmmm, seems we discovered something that works differently in a saved .fex and entered directly at the >>