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]
