case sensitivity in Crystal report

[Former Member]

(ucase("value")="value");

//returns true

even though

ucase("value")//returns VALUE

Is it due to case insensitivity that

"VALUE" = "value"

Rgds,

Ansari

[Former Member]

Yes.

-Prathamesh

[former_member203168]

Hi Farhan,

In below case
(ucase("value1")="value2");

You are comparing the value1 with value2, so if the value1 is = value 2 then it will give boolean value i.e., True or False.

In second case

ucase("value")

You are performing UCase function, means it will convert the filed value into Upper case value.

--Praveen G

[Former Member]

I know for sure that i m comparing value1 with value2.

i do know the functionality of Ucase.

I never asked u about it.

if "VALUE"=value //returns true

does it ignores case sensitvity and that's why it returns true or

something else is the reason behind this?

[former_member205840]

Hi

As I said in my earlier post, Crystal is not a case sensitve, If your database is case sensitive then when you compare

If "VALUE" = "value"  (where "value" is coming from your database field) then it says false.  In this case you need to modify your formula as

If "VALUE" = UCASE("value")  this will display true

Hope the above is clear..

[former_member205840]

Crystal is not a case sensitive, if your database is case sensitive then you may have to use Ucase / Lcase / ProperCase to compare database field values.

Thanks,

Sastry