Alan Try this:
lnLen = LEN( lcString) lnSpacePos = INSTR( 1, lcSTring, " ") lcNewString = LEFT$( lcString, lnSpacePos-1) + RIGHT$( lcString, lnLen-lnSpacePos) Terry -----Original Message----- From: Alan Gunn [mailto:[EMAIL PROTECTED] Sent: 30 March 2005 00:59 To: Terry McDonnell Subject: MI-L Trim in the middle Hello all, Does anyone know how to take a whitespace character out of the middle of a string? Thanks, Alan --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 15915
