kindly help me
i have a table with these columns
(
month int null,
year int not null,
acct_no char(15) not null,
acct_type char(10) not null,
effective_dt datetime null,
late_fee_to_dt)

the field effective_dt is null and i want it to be populate by a value which d=should be composed of '29' then the respective value of column month and respective value of column year,
kindly help me do a script to update the effective_dt.

will appreciate your assistance
--

Best regards
Esther Wambugu