Thanks Peter but this string doesn't seem to work either. I notice I left
out some important information in my initial posting. I updating the
"streets" table, column "onpage" from a the table "11x17index"
by the value of "within" column "page"
The final result provides an index of what page any given street may be
found within a map book I have produced.
Thanks again, I'm headed to the printer today to have some drafts printed up
and can make do with what I have so far so it's not that I can't live
without showing the mulitple pages.
David
----- Original Message -----
From: "Peter Meier" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, July 31, 2000 4:45 PM
Subject: RE: MI Syntax to append using Update Column
> Hi David,
>
> Try this as your update value:
>
> LTrim$(OnPage+Chr$(32+12*Sgn(Val(OnPage)))+"2")
>
> Regards,
> Peter.
> ==============================
> Peter Meier
> [EMAIL PROTECTED]
> SpatialPlus
> http://www.spatialplus.com
> ==============================
>
>
> >
> >Greetings list,
> >
> >I have a column I have performed an "Update" to, updating "Selection"
column
>
> >"OnPage" with "1".
> >
> >I now wish update this column once more with existing content "1" while
> >appending ",2" to the initial value to acheive the result "1,2"
> >
> >I've accomplished this with nearly exceptable results except where there
is
>
> >no initial value in which case I recieve the value ",2"
> >
> >Onpage + ",2"
> >
> >I guess what I'm needing to do here is "trim" the comma "if" there is no
> >initial data. I just can't seem to figure out the syntax.
> >
> >If there is no initial value the result would be "2" not ",2"
> >
> >Thanks
> >
> >David Reid
> >GIS/Database Mngr
> >Colbert County E-9-1-1
> >Colbert County, Alabama
> >[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]
>
> ----------------------------------------------------------------------
> 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]
