I know there has to be a simple answer but right now, I'm not sure what it is.
I have to append one column to another but it has to fill the last two places in the column. Column one: char(50) Mr. Jeff Fisher Mr. Someone Else Column two char(50) ** * Desired outcome mr. jeff fisher ** mr. someone else * ok, that didn't look right using non-monospaced font! --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.