Tag: string-matching

SQL inner join on column A and compare values in column B

inner-join sql sql-server string-matching

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], […

How to show only rows where there is no match between strings at all?

sql sql-server string-matching

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 Bl…