I have to import daily payroll hours reports from the payroll department into my database every day in order to calculate each employees efficiency for the previous day. The trouble is that in my database, employee ID numbers are 3 digit "strings." Ex: 020, 041, 116, 291, etc etc... But the report from payroll has them stored as 4 digit strings. Ex: 0020, 0041, 0116, 0291. Is there any way other than simply changing each record manually to take off the leading zero on all the 4 digit employee ID codes?
Thanks! Any help is appreciated.
Brooks Tilson
Database Development
Tilson Machine, Inc.
Thanks! Any help is appreciated.
Brooks Tilson
Database Development
Tilson Machine, Inc.