Subject Re: [firebird-support] Re: Length of String < 10 in SQL Statement - how?
Author Ann W. Harrison
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.