Having a brain fart and can't figure this out...
I have 2 databases I need to join:
db1.customer.customer_no char(15) right justified, zero padded
sample customer numbers:
000000000000001
000000000000010
000000000000234
000000000012345
db2.customer.customer_no varchar(20) left justified, no padding
sample customer numbers:
1
10
234
12345
How do I join tables on customer_no? Use cast, convert? Strip zeroes from
db1 table?
Thanks.