Help Me Please, Im trying to search for a certain string that may be present in one or all columns of a table

I have been asked to search a database table for a number string that some users have populated inserted the information into the wrong field.

Is there a way of searching all the columns in the table for the required string.

%11230%

The original column is a Varchar2 10

I have whittled down the columns (205 in said table) using the dba_table_columns view down to about 100

Thanks in Advance

Raymond Craig
CSC DBA Received on Tue Jul 31 2001 - 07:37:24 CDT