hi_feroz wrote:

>
> ... And I
> found that some of the barcodes have been entered incorrectly. Just
> wanted to find out a quick way to get wrong barcodes.

The checks we discussed would be fine for a one-time scan of 500 record.
A similar check in a trigger to reject incorrect barcodes would be a
good idea. I was afraid you were thinking about something that might be
used as a joining term, in which case storing the length in a separate
field that could be indexed would be important.


Regards,


Ann