At 12:36 PM 09/08/1999 +0200, [EMAIL PROTECTED] wrote:
>Update "table" Set WGS84_MIN_X =
>Int(WGS84_DEC_X)+"°"+(WGS84_DEC_X-Int(WGS84_DEC_X))*60
>Update "table" Set WGS84_MIN_Y =
>Int(WGS84_DEC_Y)+"°"+(WGS84_DEC_Y-Int(WGS84_DEC_Y))*60
>Alter Table "table" ( modify WGS84_MIN_X Char(10),WGS84_MIN_Y Char(10) )
>Interactive
>Update vegetation Set WGS84_MIN_X = WGS84_MIN_X + "'"

 >The result looks like: 10°49.533' and 9°2.98872' But I would like to see the
 >last result like 09°02.989'

To get a leading zero, change

         Int(WGS84_DEC_X)...

...to...


         Right$("00" + Int(WGS84_DEC_X),2)...



Steve Wallace
GIS & Market Information Manager
Florida Farm Bureau Insurance Companies

----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]

Reply via email to