i want to join column with specific match case : i have two tables TableA and TableB the TableA having column called Code Like 'A','AB','B','BB' in TableB i have column called pnrcode like 'A001','AB001','B001','BC001' both table has no relationship i want to join this two table based on TableA code with TableB pnrcode with matching the characters based on TableA