I have a SQL database with asset numbers that begin with an X (i.e. X80435 or X7147121, etc.) I'm trying to pull the information related to that specific asset tag, but when I scan it in the query it has a space after the last number and it doesn't find it.
The query parameters are Like "*" & [Enter Asset Number] & "*". If I manually enter the asset tag, I get the information. If I scan the barcode with a scanner, I get nothing. I've reprogrammed the scanner to make sure it has a carriage return (and nothing else) after the scan.
This is only a problem on one particular device, but we have about 16,000 of these devices, so it's a BIG problem. Is there any way I can scan a number and parse out any spaces at the end in a query?
Thanks in advance for any help you can give me.