Like Operator in Oracle 9i

[seequal]

Hi,

I am trying to find a way of evaluating whether the elements of a given string are either numeric or alpha characters

In T/SQL I would simply do the following:-

SELECT * FROM Table
WHERE UPPER(Field) LIKE('[A-Z][0-9][0-9][0-9][A-Z][A-Z]')

Can't seem to find a simple way to replcate this in Oracle 9i.

Can anyone give me a pointer ?

Thanks

 

[lewisp]

SELECT *
FROM   table
WHERE  Translate(Translate(Upper(field),
       'ABCDEFGHIJKLMNOPQRSTUVWXYZ','~~~~~~~~~~~~~~~~~~~~~~~~~~'),
       '0123456789','@@@@@@@@@@') = '~@@@~~';