Ignacio, Si tus columnas son numericas hace esto:
Update Table Set Col_7 = Str$(Col_5) + Str$(Col2) Si no siempre tenes 5 y 2 digitos respectivamente pero el campo resultante tiene que tener 9 cifras, tenes que usar el format$ para agregarle 0 o espacios a la izquierda Suerte, Alejandro ----- Original Message ----- From: "Ignacio Garc�a" <[EMAIL PROTECTED]> To: "Mapinfo-L@lists. directionsmag. com" <[EMAIL PROTECTED]> Sent: Tuesday, April 02, 2002 4:00 PM Subject: MI-L easy question Hello to everybody: I have a table with two columns; first has 5 numbers ( ie:12345), the second has 2 numbers(ie: 01) I need to add a new column to the table composed by the 7 numbers (ie: 1234501). How shall I do this? Thanks in advance --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
