Identifying alpha characters only - help

From: Lakeuk <djw_123m_at_hotmail.com>
Date: 31 Jul 2002 03:09:44 -0700
Message-ID: <bcdae9a0.0207310209.3db4eab2_at_posting.google.com>

I have a list of values in a column of which I only want my results set to contain the records that match 3 alpha characters

Value

---

AAA
001
002
AB
A
BBB
BBB Using the data set above I want my query to only identify the following records

Result

---

AAA
BBB
BBB Has anyone got any ideas of what SQL I need to write to get the required result, I know I need to use the length function to match the 3 characters but I don't know how to identify alpha character only (non numeric)

I'm using Oracle / PLSQL, note the above example is a small set of data

Any help appreciated
Thanks

Dave Received on Wed Jul 31 2002 - 12:09:44 CEST