Subject Re: Length of String < 10 in SQL Statement - how?
Author hi_feroz
hint, on a big table, it's going to be
> dreadful.

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