>From MapBasic window: Update MyTable Set ColName = "pipe " + ColName
Be sure to place spaces in the text string so that when it concatenates the word with the already_there_text there will be a space. The plus sign is a keyword to concatenate, as opposed to the ampersand (&) used in some SQL. This will not work on numeric data type fields since "pipe" is not a number, so you may need to reformat the field in table maintenance. Save a copy first, and be sure there is a key field to re-populate the new, converted field from the backup if the data is lost when changing field data type. Using the Update Table wizard, select the table and column to update, get value from same table, in the value field use the assist button and place the text to add in quotes, the plus symbol, and the select the proper field from the pull down to add the text to. William "Woody" Woodruff Zoning Administrator Charter Township of Union, Isabella County, Michigan -84.80947000 43.61095100 2010 S Lincoln Rd, Mt. Pleasant, MI 48858 (989) 772 4600 EXT 41 Visit our web site at http://www.geocities.com/ctuzoning/index.htm -----Original Message----- From: Carolyn Bergin [mailto:[EMAIL PROTECTED] Sent: Monday, December 22, 2003 23:14 To: MapInfo-L Subject: MI-L Update column Help Hi Can anyone tell me how I can add the word "Pipe" to the beginning of an already populated field. I basically want what is already in the field to remain and for the words pipe to be added to it. Thanks Carolyn GIS Officer Manly Council (02) 9976 1593 [EMAIL PROTECTED] --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9680 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9690
