Vinesh,
If your column is a number field rather than a character field you can
expand on Mike's idea by including the Str$() function.
eg
update mytable set newcol = left$(str$(id_number),2)
Alternatively if you are sure the id_number is always 10 digits you can use
the INT function and
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