Oracle isalpha() function?

From: Roland Olsson <roland.olsson_at_crepido.com>
Date: Wed, 24 Nov 1999 11:21:06 +0100
Message-ID: <383BBC12.DB12F6A5_at_crepido.com>



Hi,

I'm wondering if anyone out there knows how to determine if a specific character belongs to the alphabet of the current locale? What I would like is to have a function 'FUNCTION isalpha(c IN VARCHAR(1)) RETURN NUMBER' that returns true (1) if c is alphabetic and false (0) if c is not in the set of alphabetic characters. Maybe there is a built-in function that I have missed?

I use Oracle 8.1.5/Enterprise edition.

Please help,
/Roland Received on Wed Nov 24 1999 - 11:21:06 CET

Original text of this message