On 4/13/07, dd yakkali <dd.yakkali@xxxxxxxxx> wrote:
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
how about this: select regexp_replace(string,'[^[:cntrl:]]') from dual; --returns just control characters. -Madhu S