> > hi Experts,
> > I have a problem of correpted data in my data base table. In my application a perticular table contain large amount data. This table is having a field payam N(10,2) in structure.
> > My problem is that while iserting values in this field some time ******* value is saving in the field. I found the problem with this. It is coming when we try to enter values that cannot be accomadated in that field.
> > Is it possible to fet the data back. If not can any one help me to select only those record that commeing as ****. It is not possible for to search one by one since it conatain a large amount of data. I want to eliminate those record comming as *** thoriugh some query.
> > Renjith
>
> its very simple dear you can index on that particular field and the records containing ******* will appear together
>
> Regards
> Bhushan Sahni
> Millenium Softwares
> bhushan_sahni@yahoo.com
>
> Visual Foxpro a dream house for developers

Thank you for the replay. But as i mentioned i bhave already tried this. i got all the fields togther. But for my process it is not enough. I am converting all these record into oracle.
renjith