I am sure or maybe hope there is a simple way to do this. Below is my latest attempt. The query should return only one row, but I get 31. Query: `select distinct a.[EC CERS], a.[EC Tank ID], […
Tag: string-matching
How to show only rows where there is no match between strings at all?
I have to compare two columns and be able to extract only rows where there is not even a partial match between strings. For example, I have this table: Col1 Col2 John Smith John Smith ltd Pepper Row Whatever Pepper red Blue The only row I should be seeing after the filtration is the last one: Col1 Col2 red Blue