Thanks all. That did the trick. I'll have to look up the differences between TRIM and LTRIM. Learned two things today, how to use a left join (very helpful) and this new TRIM function. You read about this stuff but don't always get the chance to use it. Best regards Bob C
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Friday, March 07, 2008 7:22 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Excel download help At 06:38 PM 3/7/2008, Castanaro, Bob wrote: >For example '000121, except the apostrophe is a little triangle in the top >left corner of the cell. So I try to download this, and of course, there is >a SPACE before the numbers. Tried as csv, no change. Cannot seem to reformat >this out. My problem is I'm using this number in a left join, and of course >it doesn't work. Tried the SGET command to see if I can fix this in >my table, >no luck. Always leaves a space. Any suggestions??? I'm getting a headache. Bob, If your goal is to delete the pre-leading space, try the (LTRIM(colname)) function to achieve your goal. New LTRIM function trims leading blanks from text, returning a text string. Example: UPDATE tablename SET colname = (LTRIM(colname)) That should take care of your specific scenario. Very Best R:egards, Razzak.
