I am trying to write a stored procedure to do the following below:
The printed check file has a name that looks like this: A111111B222222222C3333333333D50E50.PDF.*
In the example name above, 111111 is the check number, 2222222222 is the routing number and 3333333333 is the account number.
The letters define the piece of data that follows.* *
·******** A = Check number
·******** B = Routing number
·******** C = Account number
a. stored procedure to pull the check number, routing number and account number from tblCheckRegister.
b. Join them together in proper format.
b. Once it has done that, do a wildcard search on a table called tblSIValidate column SIBarCode.
c. The return value should be the entire SIBarCode column.* Append the .PDF to it and look in the same image directory as the cancelled check.
I am used to VB.net and vbscripting and the syntax there. I am sure there are things below in the stored procedure that are not correct.
Any help is appreciated.
I've edited two of the posts in this thread to hide the ABA routing number, the checking account number, and the check number. Live banking information should never be published because it can be easily misused, the liability is potentially huge even though this information is readily available to the financial industry.