Re: Update problems ...
From: PPlewes <pplewes_at_aol.com>
Date: 1995/07/27
Message-ID: <3v9613$b4i_at_newsbf02.news.aol.com>#1/1
Date: 1995/07/27
Message-ID: <3v9613$b4i_at_newsbf02.news.aol.com>#1/1
You can also do:
Select rtrim(serial_number) from ammo a1 where exists (select null from ammo a2 where a1.rowid<>a2.rowid and
rtrim(a1.ammo)=rtrim(a2.ammo));
This will give you the duplicate serial numbers after being trimmed. Received on Thu Jul 27 1995 - 00:00:00 CEST