billd6 Posted September 13, 2011 Share Posted September 13, 2011 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 Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.