> 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