COL1+" "+COL2+" "+COL3 Would produce:
COL1 COL2 COL3 -----Original Message----- From: Robert Schumacher [mailto:[EMAIL PROTECTED] Sent: Monday, December 13, 2004 3:51 PM To: [EMAIL PROTECTED] Subject: MI-L Need help inserting spaces when concatenating columns When I am using concatenation to update a column, how do I place a blank space between each column in the concatenation? Does MapInfo use a certain character to denote a blank space? What would the expression look like? (Iattempted to do this by creating a new column in the table and setting the value of that whole column as a blank space (" "). When I concatenate by placing this new column between all other columns, no blank spaces show up in the updated column. All of the characters are bunched up together.) Thanks, Rob Schumacher --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.804 / Virus Database: 546 - Release Date: 11/30/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.804 / Virus Database: 546 - Release Date: 11/30/2004 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 14533