Hi Peter,
Try this
Update "table" Set WGS84_MIN_X =
Format$(Int(WGS84_DEC_X),"00")+"�"+Format$((WGS84_DEC_X-Int(WGS84_DEC_X))*60,"00.###")
Update "table" Set WGS84_MIN_Y =
Format$(Int(WGS84_DEC_Y),"00")+"�"+Format$((WGS84_DEC_Y-Int(WGS84_DEC_Y))*60,"00.###")
Hope this helps.
Regards,
Sue
++++++++++++++++++++++++++++++++++++++++
adding Susan Port
value Technical Support Coordinator
to [EMAIL PROTECTED]
your
spatial Spatial Plus
systems http://www.spatialplus.com
++++++++++++++++++++++++++++++++++++++++
>I have a question about how to print a integer below 10 like 01
>
>I run something like this
>
>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'
>
>I could use SQL, select *<10 but is there a more direct way to it?
>
>Thanks
>
>Peter
>
>
>----------------------------------------------------------------------
>To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
>"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
