RE: RE: RE: Find an unprintable character inside a column....

2003-10-10 Thread Stephane Faroult
Some people have requested this code, so I thought you might as well all have the chance to pick it to bits... Its a function called BAD_ASCII, and it hunts out for any ascii characters with an ascii value of less than 32 in a specified field. (Acknowledgments to my colleague Keith Holmes for help

RE: RE: RE: Find an unprintable character inside a column....

2003-10-10 Thread Jared . Still
in the WHERE clause in 10g will be nice. Jared Stephane Faroult [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/10/2003 07:09 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: RE: RE: Find an unprintable

RE: RE: RE: Find an unprintable character inside a column....

2003-10-10 Thread Mladen Gogala
Stephane Faroult [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/10/2003 07:09 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: RE: RE: RE: Find an unprintable

RE: RE: RE: Find an unprintable character inside a column....

2003-10-10 Thread Jared . Still
PROTECTED] cc: Subject:RE: RE: RE: Find an unprintable character inside a column Actually, I was toying with the idea of writing an external procedure that would allow me to call pcre library (PCRE=Perl Compatible Regular Expressions) which would be nice, but then again