I have forumula field which is supposed to return a string. I have if/else statement set as below:
if ({Customer.ordernum} startswith "V") then

The problem is that it is returning Y even if ordernum starts with a lower case v.
order 1= v12345 -> FORUMULA FIELD incorrectly returns "Y"
order 2 = V0001 -> FORUMULA FIELD correctly returns "Y"
order 3 = P12546-> FORUMULA FIELD correctly returns "N"

I have tried using uppercase, lowercase, chrw, mid functions and nothing has worked so far. Is there a setting in crystal that I can fix this issue? What am I doing wrong. Any help is appreciated!
Lolo 70