Sure:
Select * From MYTABLE
Where A < C
Into TO__UPDATE NoSelect
Update TO__UPDATE Set X = B
Select * From MYTABLE
Where A > C
Into TO__UPDATE NoSelect
Update TO__UPDATE Set X = D
As you can see you need to do a select and then update the selected records.
HTH,
Peter Horsb�ll M�ller
GIS Developer
Geographical Information & IT
COWI A/S
Rug�rdsvej 55
DK-5000 Odense
Denmark
Tel +45 6313 5013
Direct +45 6313 5008
Mob +45 5156 1045
Fax +45 6313 5090
E-mail [EMAIL PROTECTED]
http://www.cowi.dk
> -----Original Message-----
> From: Lathrop, Travis C [PCS] [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 30, 2003 4:07 PM
> To: [EMAIL PROTECTED]
> Subject: MI-L Update Column Help
>
>
> I want to update column x with either column B or D. I want
> MapInfo to compare column A and column C to decide whether to
> populate x with B or D. Basically something to the effect of:
>
> Update X with B if A<C or Update X with D if C<A.......
>
> Can someone please tell me if I am missing something?
>
> Travis Lathrop
> Intercarrier Services
> 913-762-8064
>
>
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 8963
