Re: MI-L Label expressions again (min max)

[Trey Pattillo]

Hello,   the nesting might get deep here but it works use Format$ with #### which will not display 0'x   FORMAT$( MINIMUM( FromLeft, FromRight ) , "######" )   but what happens when the street is drawn backward to the addressing   FORMAT$( minimum( mininum(FromLeft,ToLeft) , minimum(FromRIght,ToRight) ) , "######" )   Trey Pattillo 911 operations Mgr & GIS Coastal Bend 911 Corpus Christi, TX work: [EMAIL PROTECTED] web: www.cbcog98.org   home: [EMAIL PROTECTED] where this came from web: http://www.wap3.com   ------------------------------------------------   To ME or not to ME, that is the question. For some it will be to Whistle and indure the thorns and thistle. For me it is not to ME, but to NT, The OS for ME ! ----- Original Message ----- From: David Reid To: MapInfo-L Sent: Wednesday, 24 January, 2001 12:42 Subject: MI-L Label expressions again (min max) Greetings list, Now that I have once again pulled my hair out over an issue, I call on the list for help :) I'm trying to create an auto label expression that will label with the minimum of two columns (fromleft fromright) yet return the number greater than 0 if there is such a number. (ie Minimum(fromleft, fromright) ) More simply put, I want from two columns, the least number "greater" than zero "0". Example: FromLeft   FromRight     Low 1                      2                 1 0                      4                 4 9                      0                 9 Would produce a label displaying the lowest address number greater than zero. ______________ David Reid GIS/Database Manager Colbert County E 9-1-1 Colbert County Alabama [EMAIL PROTECTED] _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.