Hello experts -
I know the answer to this one but I just cannot seem to remember it.
I have created a forumla to concatenate name fields but am having a problem if there is a middle name. I have placed the isnull command in the appropriate place so if the constituent has no middle name it will be replaced with '', but I cannot seem to figure out how to put the a space between the middle name and the last name if the constituent has a middle name. For example,
John Doe shows as John Doe but John H. Doe shows as John H.Doe. I have attached the code.
,rtrim(r.reltitle)+' '+RTRIM(r.relfirst)+' '+isnull(rtrim(r.relmiddle),'')+RTRIM(r.rellast) as ContactFullName