Hi Everyone,
I am trying to connect database thru VB and it works. But, i am reading an input from other workbook. My required input should be 9 digits. While am reading the input there is a chance of input with less than 9 digits. So,i want to make sure that changing the input value into 9 digits and i tried with
"ssn =FORMAT( x.Sheets("Sheet1").Range("B" & i).Value, "000000000")" but it showing an error called " '[IBM] [CLI Driver] [DB2/LINUXX8664] SQL0420N Invalid character found in a character string argument of the function "DECFLOAT".SQLSTATE =22018."
Example :
Input sheet : 123456
Required data : 000123456
Bookmarks