Check in the database with first 12 numbers... - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

Check in the database with first 12 numbers...

altafingaraltafingar Posts: 29Member
In my database i have a column name BarCode and part Number Barcode is 12 digit when my user scan the barcode in textbox it gives them a partnumber related to that now what i want to do is scan a barcode that has 16 number as barcode but in the database it has first 12 digit same so basically i want to do is that check in my database only the first 12 numbers and dot check the last 4 number and give me the part number related to that...
so for example in my DATABSE I have Column Name BARCODE the content of that column is lets say 123456789123 and PART NUMBER IS A-1111. ok now my user will scan a barcode in a textbox the barcode user will scan is => 1234567891234567 so the first 12 digit is same as what i have in my database right? so any time if first 12 digit of what user scan match with what i have in my database the program will output the part number in this case A-1111.



Sign In or Register to comment.