I'm trying to join two tables together where the key from the host table is a two digit number stored in packed format, and the secondary table is a four digit number stored in a char(10) field.
For example, the value from the host would be 23 and the value that it would match to in the guest would be '1023', so 1000 needs to be added to the value in the host, converted to char(10) and matched on the guest.
I've tried to use cast, but recieved an error that char could not be used.
I was wondering if anyone might have some other ideas on how this might be possible.
For example, the value from the host would be 23 and the value that it would match to in the guest would be '1023', so 1000 needs to be added to the value in the host, converted to char(10) and matched on the guest.
I've tried to use cast, but recieved an error that char could not be used.
I was wondering if anyone might have some other ideas on how this might be possible.