You can use an SQL statement to make the updates.
UPDATE
Tablename
SET
Col2 = '1'
WHERE
Col1 = 'Slight'
- Jeff Koncz
Directions Magazine
http://www.directionsmag.com
-----Original Message-----
I'm struggling with an expression can anyone help?
I have a table containing accidents of different severity levels. I want to
update a new column in the same table with an integer that relates to the
severity eg. If Col1 = "Slight" update Col2 with "1". Can I use an IF
statement to achieve this?
Thanks, Dave
----------------------------------------
David A Eagle - GIS Specialist
Transport Planning
WS Atkins Consultants Ltd
Wellbrook Court, Girton Road
Cambridge, CB3 0NA
Tel: 01223 814090
E-mail: [EMAIL PROTECTED]
----------------------------------------
This email and any attached files are confidential and copyright protected.
If you are not the addressee, any dissemination of this communication is
strictly prohibited. Unless otherwise expressly agreed in writing, nothing
stated in this communication shall be legally binding.
_______________________________________________________________________
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.
_______________________________________________________________________
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.
