If your string column is e.g. "typeofhouse" and it is either: villa cityhouse appartment school government
create a new int column named typeid and set an id to each type. update houses set typeid=1 where typeofhouse='villa' You then have the typeid column updated as this: villa=1 cityhouse = 2 appartment = 3 school = 4 government = 5 Add the same typeid column in the other table and update this the same way. Tjen you can join using the int column instead of the text column. Best regards Hans Milling... -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Mapguide-and-ODBC-tp5202365p5202427.html Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
