Might be advanced Update statement

From: Halvor Nyberg <hnyberg_at_eunet.no>
Date: Thu, 30 Mar 2000 10:17:28 +0200
Message-ID: <38E30D98.58691524@eunet.no>

Challenge:
I have a table like this:
Pos Parent Child ExpiredDate Info

1   1000   401   31-12-1899  U
2   1000   500   30-03-2000
3   1000   500   31-12-1899  U
4   1000   700   30-03-2000

5 1000 700 31-12-1899

In this example Pos 2 and 3 both contains Parent 1000 and Child 500. Pos 2 has Expired
(Date<>31-12-1899).

What i need is a SQL Update statement which Sets INFO of the Not Expired row equals INFO of the expired row WHERE INFO = U. --
Regards Halvor