I am creating an application that is being used by police departments. This will scan you driver license and search their database for individuals. I am using Access as the backend, with VB.Net as the frontend.
In their database, the master name file has a field for driver license number, there was no 'format' specified for this field so the number could be entered in as 12345678 or 12 345 678 or a combination in between.
When the license is scanned from the barcode it comes in as 12345678.
My situation is that I need to do a select query on the driver license number including any varation of spacing on that field.
Could I run a select statement, formatting the database field (which is mastname.olnno) to replace all spaces with no characters. Not sure how I can do this though. Can I run a replace function on the field itself in a select statement? If not, how can I go about getting this resolved?