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