Excellent question. I often come across code such as

IF col1 like col2 (without any wildcards)

and I've often wondered why they didn't just put IF col1=col2. Til today I assumed they were equivalent. (I wonder if those that wrote this code appreciate the nuance.)

Thanks for expanding my knowledge.