identify upper or lower case in a formula 1

[VE]

Hi,

In my data "C" means something different from "c". I need to write a formula that will identify the case of the letter.

I have tried
if {field1} = lowercase("c") then {field2} else ""

and I have tried
if {field1} = chr(99) then {field2} else ""

I unchecked the box under options for case insensitive

are there any other ways I can do this?

Crystal 2011 and a DB2 database

thank you
VE

 

[pmax9999]

I got it to work like this:

IF    Instr({field1},CHR(99)) > 0 
THEN  {field2} 
ELSE  ""

Hope this helps.

Cheers
Pete

 

[VE]

That seems to be getting me there. I think if I also check the length I can filter out the fields that have small c as part of the field and I'm set. Thank you very much!!