Hi All,
I have two fields to concatenate
A=(011)7171361
B=(o)
C=A:B
When I do Concatenation of A:B iam getting the value as C=A(B value is not concatenated)
But when I do C=B:A this is working fine.
Do some one has clue why this is not working for C=A+B
Iam writing the data to a DataSet
Regards
Cherry
Concatenation
Moderators: chulett, rschirm, roy
Re: Concatenation
Hi Cherrycherry wrote:Hi All,
I have two fields to concatenate
A=(011)7171361
B=(o)
C=A:B
When I do Concatenation of A:B iam getting the value as C=A(B value is not concatenated)
But when I do C=B:A this is working fine.
Do some one has clue why this is not working for C=A+B
Iam writing the data to a DataSet
Regards
Cherry
You have to make sure that B is not null (seems to be the case for you).
So I suggest you do this :
If isNull(A) Then '' Else 'A' : If isNull(B) Then '' Else 'B'
Please update if that works
Arnaud
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom