I have a field called All_Data in my Oracle database that containes 2000 characters. This data is a combined string of a large info. I want to create an Searchable Index on Customer Number, which is a part of All_Data.<BR><BR>I may had to create another field called Cust_No. and extract customer Number from All_Data, and populate Cust_No field. But Somebody suggested that a Oracle function called INSTRING can create a seachable index on a part of All_Data.<BR><BR>If somebody can help me doing that, it will be great!