Jump to content

Prefix + First + Last


Recommended Posts

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





Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...