To update single column of multiple table

[Manisha Patil]

I want to update one column tht is. description of multiple tables by checking the condition description not greater than 40 character . If it is then update that column to 40 charater.
How to do this by using stored procedure in sql server 2005.

create procedure chng
as
begin
update description from location set substring(descr iption,1,40) where len(description )>=40
end

but this is for one table ..
How to do foe multiple tables...

[Rabbit]

Change the table name.