Hi @Sherlan Emmanuel Burgonia
Have you validate the answers in your previous thread?
SQL: Query that finds the ID from a string
SQL Query that looks for ID number
If these two issues has been solved, please don't forget to accept the answers if they helped. So other users with similar problem could see this easier. :)
Back to the current issue,
I was thinking to use LIKE % but I'm not sure how.
I don't think LIKE is a good choice to join these two tables.
You could use string functions to ignore first three digits, as i answered on your previous thread. Like this:
select *
from table1 t1 join table2 t2 on RIGHT(t1.ID,LEN(t1.ID)-3)=t2.ID
Best regards,
LiHong
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.