HELP!

From: Michael <mjjugs_at_gofree.indigo.ie>
Date: Sat, 28 Aug 1999 16:49:10 +0100
Message-ID: <%LTx3.4673$r4.2668@news.indigo.ie>

I am trying to select the first seven char of 8 characters column within a large table & then compare this with existing seven char columns. If there is a match then I need to delete the seven chars.

eg.

Table X

House_ no
A1093459
A109345 >needs to be deleted
B2062768
B206276 >needs to be deleted

I have tried

DELETE FROM (SELECT * FROM X
WHERE HERD_NO LIKE SUBSTR(HOUSE_NO,1,7)||'_') but this deletes 8 characters Received on Sat Aug 28 1999 - 10:49:10 CDT