I have a field in a DB2 database where the value is a string but can different cases (a vs. A) and they mean different things. When using an IF/THEN statement it sees the value as the same. Does anyone know how to distinguish the difference? In other words, my IF/THEN statement is saying… “IF {Field} = “a” then “RED” ELSE
IF {FIELD} = “A” then “BLUE” ELSE…” Any thoughts?
thebenson5 (BOB member since 2018-11-29)
If I recall correctly. You can set your data source to be case sensitive.
File, Options, Database tab, Database Server is Case-Insensitve check box, should be unchecked. (at least on CR 2016). It has been a long time since I had to deal with case sensitive situations. I am assuming it works.
kevlray 
(BOB member since 2010-06-23)
There are couple of functions that works on Unicode values of a given string or number, AscW() and CharW(). You can try using them. It may help.
Example:: Below statement returns False.
if AscW (‘a’)=AscW (‘A’) then true else false
anil.ganga1 (BOB member since 2007-07-04)