[Solved] Return row in SQL that returning null value? to show them not as blank value
You can left join to a derived table containing the “numbers” (well, strings with a possible numeric representation actually). SELECT d.clientnumber FROM (VALUES (‘00602’), (‘00897’), (‘00940′)) AS n (n) LEFT JOIN dataentry AS de ON de.clientnumber = n.n; That’ll give you as many NULLs as “numbers” in the list that aren’t present in the table … Read more