Concatenate fields

MTmace

Member
Joined
Feb 1, 2005
Messages
9
Programming Experience
Beginner
I have a data table with a couple of fields (firstname, lastname). I am trying to create a third field with first and last name combined. The problem is sometimes the first name is null.

newcol.Expression = IIf(IsDBNull(m_Claim.polNameAddress.Columns("FldAddNameFirst")), "FldAddNameLast", "FldAddNameFirst + ' ' + FldAddNameLast")

I have the above code will always perform the the "else" part. Since the first name is null the value in the field I am binding too will show null instead of the last name.

Any ideas how to fix my problem?


MTmace
 
Back
Top