Ok, I feel pretty stupid now. After writing this pretty nifty program to replace a rather silly tool we have to use at work, I was stumped on this one for quite some time. I tried many different functions, all of them returned what I thought was erroneous results. At the end of my program, I created a cursor and dumped those results into a text file via sdf. Then I would compare the text files byte for byte using my handy dandy Ultra Compare. It should have been the simple part: and it was. The portion that needed to be appended was actually at position 33, not 50.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Vince Teachout Sent: Monday, October 16, 2006 8:34 PM To: ProFox Email List Subject: Re: appending issue Jeff Fisher wrote: > 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 * > > If I understood the problem correctly, you could use: REPLACE ALL Column2 with Left(Column1,48) + Right(Column2,2) [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] 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.
