How to copy a row ?

Hi, As the subject says, I want to duplicate a row in a table. To understand me, read the following SQL statement and tell me what you think about it : insert into lang(id, descr) select 9, descr from lang where id=4; So I choose the row with Id=4 and copy it into the same table with a new Id (9). Well, It DOESN'T WORK !!!!! :( (But it works with Oracle !!! :)) Can someone tell me how to do that damned copy (in a single request if possible and without using temp tables) ? TIA. Alain (Alain.Leroy@csl.sni.be)