Converting String to Number via Code VBA SQL Server MS Access
Posted on 2006-05-12
I am scanning a barcode that reads into a textbox as follows..
I have a Sql Server where the value is being stored..
it is saved into the DB as
9090972, the field is a number datatype
Later on, I am scanning the barcode again to do some things, this value has to be compared against the earlier stored value in the DB (9090972)
I have been fooling around with the CInt function, to convert a string to a integer..but I am getting an overflow error.
How do you codewise convert a string to a integer, in other words ...I want
09090972 --> 9090972
CInt function won't work..
Any help or insight would be much appreciated