Hi

If your DB field is numeric then you could just do a where 'fieldName' >
9999999999. This will find all barcodes that are too long. It wont,
however, find all the miskeyed ones where the ceck digit is incorrect.
You probably need code / stored procedure to do that.

Hope I that helps.

Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd



hi_feroz wrote:

>
> hint, on a big table, it's going to be
> > dreadful.
> >
>
> Ann,
> I am in the midst of developing a small Library System which has
> BOOKS_MST as the Library Material Master. A gave them a part of
> application where they can start entering data into BOOKS_MST. At
> that time, it was not decided yet what and how long the barcode is
> going to be. So, I had not put any control in the application side
> yet. Then it was decided to be String(10). Barcode scanners are yet
> to be received, so they are entering barcodes manually as well. And I
> found that some of the barcodes have been entered incorrectly. Just
> wanted to find out a quick way to get wrong barcodes.
>
> So, do u have any suggestions in this case?
>
> I have already put few controls in my application now... so I guess
> data entry errors are much reduced. But there are some records in
> those 500 records where the barcode entered is wrong.
>
> Current Records = 500
> Total Current Meterial in Library = 3000
> Total Material to be expected in Library by April = 30,000
> Total Material to be expected in Library by December = 90,000
>
> Feroz
>
>
>
>
> ------------------------------------------------------------------------
> *Yahoo! Groups Links*
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> * To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>