I have an issue where i have 2 tables. Each table has information related however there is prefix before each item. Some prefixes are 2, 3 , or even 4 characters. So in order for me to join the tables i need to remove all the prefixes so that i have item ID to Item ID.
Is there a easier way of doing this for example selecting using Like. I have 50,00 items that i need to upate a field on that has the item ID without prefixes.