Ok.

here is your script:

update Table1

set Code = (select t2.code

from Table2 't2'

where t1.From <= t2.From

and t1.To >= t2.To)

from Table1 't1'

assuming the real names of the tables in SQL are:

dbo.table1

dbo.table2

should the...

Thanks for now.

what do t1 and t2 in your code represent? is that the same as names for table1 and table2?