Re: Oracle isalpha() function?

From: Tom Verhagen <tverhage_at_aon.nl>
Date: Wed, 24 Nov 1999 15:20:38 +0100
Message-ID: <383BF436.486588D4_at_aon.nl>

you can use translate function as well, like

1* select translate (lower('&1'),'abcdefghijklmnopqrstuvwxyz',' ') from dual

returns fe for the charachter E a space (' ') and for a number 1 returns '1' Received on Wed Nov 24 1999 - 15:20:38 CET

This message: [ Message body ]
Next message: Bruce Rennert: "Director Of Development needed in NYC"
Previous message: Thomas Kyte: "Re: enum values in EXEC SQL statement"
Maybe in reply to: Roland Olsson: "Oracle isalpha() function?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message