Prefix + First + Last

[billd6]

I'm sure the answer is somewhere in the forum but I can't find it.

 

Some of the records in the prefix field of a customer supplied database contain data and some don't.

 

How do I eliminate the blank space current occurring before the first name when there is no prefix?

 

Mr. John Smith

Mrs. Jane Doe

Steve Jones <-- Dont want space to print

Mr & Mrs. Dan Jenkins

Bill Johnson <-- Dont want space to print

 

Thanks

 

Bill

[FreightTrain]

billd6,

 

if (Field("Prefix") != "")

{

return Field("Prefix")+" "+Field("First")+" "+Field("Last");

}

 

else

{

return Field("First")+" "+Field("Last");

}