Vinesh,
Assuming that the ID_Number column consists of characters (not an integer,
float, etc.) then you can create a new column, and then update the new
column with Left$(ID_Number,2).
Mike Jenne
At 03:22 PM 3/4/00 +0200, Govind, Vinesh wrote:
>Dear Sir
>
>I have a table with a column called ID_number that consists of ten digits
>for each individual. I would like to truncate this column to create a new
>column that will only display the first two digits of the ID_number. This
>will allow me to calculate the clients current age.
>Please assist.
>
>Thanking you.
>
>Kind regards.
>
>
>Vinesh Govind
>
>
>NBS - Marketing
>(T) 364 2106
>(F) 364 2915
>Email: [EMAIL PROTECTED]
>
>
>
>WARNING:
>Any unauthorised use or interception of this email is illegal. If this email
>is not intended for you, you may not copy, distribute nor disclose the
>contents to anyone. Save for bona fide company matters, the BoE Group does
>not accept any responsibility for the opinions expressed in this email.
>For further details please see: http://www.nbs.co.za/emaildisclaim.htm
>
>
>
>
>
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]