Philip,
It is not quite clear to me whether your variable is a column or a variable ?
And what should the variable be if it isn't -1 ?
I take it that you are talking about doing this in a SQL Statement, not in a
simple MapBasic statement ?
MapBasic:
If %_Caucasion > 0.40 then
Average Household Income = -1
end if
SQL Statement:
Val(Left$("-1", 2 * Int(%_Caucasion > 0.40))) "Average Household Income"
I hope this makes sence ?
Peter Horsb�ll M�ller
GIS Developer
Geographical Information & IT
COWI A/S
Odensevej 95
DK-5260 Odense S.
Denmark
Tel +45 6311 4900
Direct +45 6311 4908
Mob +45 5156 1045
Fax +45 6311 4949
E-mail [EMAIL PROTECTED]
http://www.cowi.dk/gis
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 05, 2005 6:52 PM
To: [email protected]
Subject: MI-L query question (if statement?)
Group,
I need some help with this equation. I have a variable of "%_Caucasion" and
"Average Household Income". Here is what i want to do.
Looking at the "%_Caucasion" variable I want to say "if %_Caucasion is greater
than .40 , then enter a value of "-1" in the Average Household Income variable.
Can this be done? Thanks for any help.
--------------------------------------------------------------------
Philip Lesnik
Research Systems Analyst, Market Research
General Growth Properties, Inc.
110 N. Wacker Drive BSC 3-13
Chicago, IL 60606
312-960-2998
312-960-5519 (fax)
[EMAIL PROTECTED]
--------------------------------------------------------------------
-----------------------------------------
+++++++++++++++++++++++++++++++++++++++++++++++++++++++ Notice: This
e-mail including attachments) is covered by the Electronic Communications
Privacy Act, 18 U.S.C. �� 2510-2521, is confidential and may be legally
privileged. If you are not the intended recipient, you are hereby notified that
any retention, dissemination, distribution, or copying of this communication is
strictly prohibited. Please reply to the sender that you have received the
message in error, then delete it. Thank you.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com | To
unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16378
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16381
