1st column: block_number
2nd column: unit_number
I want to merge the 2 columns and get a tenant_id column.
E.g. block_number = 12
unit_number = 1234
tenant_id = 121234
But i kept trying and get an addition of both columns which is 1246. How should i separate both of them but remain them as int instead of changing them to varchar.
2nd column: unit_number
I want to merge the 2 columns and get a tenant_id column.
E.g. block_number = 12
unit_number = 1234
tenant_id = 121234
But i kept trying and get an addition of both columns which is 1246. How should i separate both of them but remain them as int instead of changing them to varchar.
Comment