translate

From: Frank <franjoe_at_frisurf.no>
Date: Fri, 27 Apr 2001 18:35:13 +0200
Message-ID: <sdhG6.1142$Ty6.16049@news1.oke.nextra.no>

Hi!

If you can't catch exceptions in you environment you may work along the lines of:

SELECT DECODE(NVL(TRIM(TRANSLATE ('7a868','123456789','         ')),'NULL'),


                'NULL','NUMBER',

                'SOMETHING ELSE')

FROM dual;

where '7a868' is the input text.

The other suggestions here on your questions are a lot more readable though

Frank Received on Fri Apr 27 2001 - 11:35:13 CDT