Hi,
You just need to use "+" sign between column names in the column update menu.
Example : Column "Name" and column "Surname", you just need to update column
"Full Name" (name and surname with a space between) with :
Name + " " + Surname
Careful : no quote around column names.
Robin.
-------- Message d'origine--------
De: Ronning, Christine [mailto:[EMAIL PROTECTED]
Date: jeu. 17/02/2005 19:14
Ã: mapinfo-l@lists.directionsmag.com
Cc:
Objet: MI-L Combining text from two columns into one
Hi,
I'm new to MapInfo and SQL so sorry if this questions is very simple.
Anyways I'm trying to combine two text columns into one. What SQL command
should I be using? I'm depending on my excel knowledge and was trying to use
CONCATENATE, which isn't working! Also any good referene material I should be
looking at for SQL? Thanks,
Christine
