You could try using Format$() function like for example:

Update "table" Set WGS84_MIN_X =
Format$( Str$(Int(WGS84_DEC_X)), "00") +"�"+Format$( 
Str$((WGS84_DEC_X-Int(WGS84_DEC_X))*60), "00.####")

Regards,
    Anssi

----- Original Message ----- 
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 08, 1999 1:36 PM
Subject: MI Print Int


> 
> 
> 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]

Reply via email to