Re: Functions

From: gazzag <gareth_at_jamms.org>
Date: 23 Mar 2007 08:29:48 -0700
Message-ID: <1174663788.473079.108870@d57g2000hsg.googlegroups.com>

On 23 Mar, 15:16, kraji..._at_gmail.com wrote:
> yes but with instr we need to specify the special characters. I dont
> want that. it should be automatic like other than numbers and alphabets

Depending on exactly what you're trying to achieve, the TRANSLATE function may also be of interest:

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/functions196.htm#i1501659

HTH -g Received on Fri Mar 23 2007 - 10:29:48 CDT