I was viewing a query offline (can't post the fully query here) that contained a JOIN but instead of
having the JOIN condition for the Primary Key = Foreign key
the syntax was Primary key LIKE Foreign key. My question is I have never seen a T-SQL JOIN before like this.
If you have can you give me an example of when you would use LIKE instead of = in a JOIN.
Thanks for the help.