> > 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
>
>
> Little Trick wait for query becaz. it will slow
>

> 
> SELECT * FROM YourTable WHERE VAL(STR(NumericFieldHavingStarts))=0 into cursor temp
> select temp
> browse normal
> 

>
>
> Anil
> My Blog
thank you Mr. Anil,
I will try this and come back to you.
renjith