How to find non printable characters in a column using regexp

  • From: "dd yakkali" <dd.yakkali@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 13 Apr 2007 12:18:56 -0400

I am trying to find the records where there are non printable characters, i
am not having success with it


select * from njcrc.tblprogram where REGEXP_INSTR(description,'[[:cntrl:]]')
0;



Above sql pulls records where there are no "non printable" characters.

Can any point me to an alternate way achieving this or let me know what am i
doing wrong.



Thanks

Deen

Other related posts: