Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Display first name and last name as one complete name without any unwanted spaces
0 views
Skip to first unread message
Steve C. Black
Jul 31, 2002, 3:08:25 PM7/31/02
to
I am pulling first and last name into a form letter from two differnt fields in a database. How do I display a complete name without unwanted space between the first and last names?
Tom Geschwender
Jul 31, 2002, 3:24:56 PM7/31/02
to
Place the first name field and the last name field one space apart, then right justify the first name field and left justify the last name field.
Steve C. Black
Jul 31, 2002, 4:11:34 PM7/31/02
to
Thanks for the suggestion, unfortunately, the first name has to be left justified to line up properly on the form. Any other suggestions?
Clifford Cheng
Aug 5, 2002, 9:42:25 PM8/5/02
to
Why not concatenating the first name and last name into a new field (add space in between as needed) in your sql, give it an alias name, then use this new field for your display?
0 new messages