Title: UPDATE QUERY ..............



                        All,
                                hoping someone can help with the following ……………..

                                I have a table containing the following columns                  ROADseg ( float )               BLANK

                                                                                        ROADNO ( CHAR,9 )               EG: 2569

                                                                                        SEGNO ( CHAR,9 )                EG: 10 (note some columns have 3 figures)

                                What I need to do is ……….. Update Column ( ROADSEG ) with ROADNO and SEGNO seperated by either an underscore or / or decimal point etc.  Eg:  2569_10 or 2569/ 110 etc.

                                I can get the two columns into the new column but cannot get the seperator included …….Many thanks in advance …………..

                                                           Regards
                                                                    Peter


Peter HATTON
Senior GIS Officer
Greater Taree City Council
2 Pulteney Street TAREE 2430
phone 02 6592 5227
e-mail     [EMAIL PROTECTED] gov.au


This e-mail has been scanned for viruses by MCI's Internet Managed
Scanning Services - powered by MessageLabs. For further information
visit http://www.mci.com
_______________________________________________
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l

Reply via email to