Hi all,
I encountered a very strange problem. When i write this logic
If (A.code= "C") Then "THis C" Else If (A.code= "P") Then "This is P" Else "This is CP"
but the answer for my data are all "This is CP" but this is not suppose to have because my input data is
code
---
CP
CP
P
C
P
C
CP
CP
CP
CP
P
P
P
P
C
C
Is it my logic having problem or.....? the code is character data type. I have use UpCase, trim , ' ' and <> but everything does not work. Please help
Thank you
Unable to get the expected result
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 32
- Joined: Wed Dec 28, 2005 9:02 pm
-
- Participant
- Posts: 32
- Joined: Wed Dec 28, 2005 9:02 pm